{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Wind Statistics"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Introduction:\n",
    "\n",
    "The data have been modified to contain some missing values, identified by NaN.  \n",
    "Using pandas should make this exercise\n",
    "easier, in particular for the bonus question.\n",
    "\n",
    "You should be able to perform all of these operations without using\n",
    "a for loop or other looping construct.\n",
    "\n",
    "\n",
    "1. The data in 'wind.data' has the following format:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nYr Mo Dy   RPT   VAL   ROS   KIL   SHA   BIR   DUB   CLA   MUL   CLO   BEL   MAL\\n61  1  1 15.04 14.96 13.17  9.29   NaN  9.87 13.67 10.25 10.83 12.58 18.50 15.04\\n61  1  2 14.71   NaN 10.83  6.50 12.62  7.67 11.50 10.04  9.79  9.67 17.54 13.83\\n61  1  3 18.50 16.88 12.33 10.13 11.17  6.17 11.25   NaN  8.50  7.67 12.75 12.71\\n'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "Yr Mo Dy   RPT   VAL   ROS   KIL   SHA   BIR   DUB   CLA   MUL   CLO   BEL   MAL\n",
    "61  1  1 15.04 14.96 13.17  9.29   NaN  9.87 13.67 10.25 10.83 12.58 18.50 15.04\n",
    "61  1  2 14.71   NaN 10.83  6.50 12.62  7.67 11.50 10.04  9.79  9.67 17.54 13.83\n",
    "61  1  3 18.50 16.88 12.33 10.13 11.17  6.17 11.25   NaN  8.50  7.67 12.75 12.71\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "   The first three columns are year, month and day.  The\n",
    "   remaining 12 columns are average windspeeds in knots at 12\n",
    "   locations in Ireland on that day.   \n",
    "\n",
    "   More information about the dataset go [here](wind.desc)."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 1. Import the necessary libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 2. Import the dataset from this [address](https://github.com/guipsamora/pandas_exercises/blob/master/06_Stats/Wind_Stats/wind.data)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 3. Assign it to a variable called data and replace the first 3 columns by a proper datetime index."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2061-01-01</td>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2061-01-02</td>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2061-01-03</td>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2061-01-04</td>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2061-01-05</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Yr_Mo_Dy    RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "0 2061-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1 2061-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "2 2061-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "3 2061-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "4 2061-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "     CLO    BEL    MAL  \n",
       "0  12.58  18.50  15.04  \n",
       "1   9.67  17.54  13.83  \n",
       "2   7.67  12.75  12.71  \n",
       "3   5.88   5.46  10.88  \n",
       "4  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# parse_dates gets 0, 1, 2 columns and parses them as the index\n",
    "data_url = 'https://raw.githubusercontent.com/guipsamora/pandas_exercises/master/06_Stats/Wind_Stats/wind.data'\n",
    "data = pd.read_csv(data_url, sep = \"\\s+\", parse_dates = [[0,1,2]]) \n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 4. Year 2061? Do we really have data from this year? Create a function to fix it and apply it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1961-01-01</td>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1961-01-02</td>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1961-01-03</td>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1961-01-04</td>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1961-01-05</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Yr_Mo_Dy    RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "0  1961-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1  1961-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "2  1961-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "3  1961-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "4  1961-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "     CLO    BEL    MAL  \n",
       "0  12.58  18.50  15.04  \n",
       "1   9.67  17.54  13.83  \n",
       "2   7.67  12.75  12.71  \n",
       "3   5.88   5.46  10.88  \n",
       "4  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The problem is that the dates are 2061 and so on...\n",
    "\n",
    "# function that uses datetime\n",
    "def fix_century(x):\n",
    "  year = x.year - 100 if x.year > 1989 else x.year\n",
    "  return datetime.date(year, x.month, x.day)\n",
    "\n",
    "# apply the function fix_century on the column and replace the values to the right ones\n",
    "data['Yr_Mo_Dy'] = data['Yr_Mo_Dy'].apply(fix_century)\n",
    "\n",
    "# data.info()\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 5. Set the right dates as the index. Pay attention at the data type, it should be datetime64[ns]."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02</th>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-03</th>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-04</th>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-05</th>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "Yr_Mo_Dy                                                                   \n",
       "1961-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1961-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "1961-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "1961-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "1961-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "              CLO    BEL    MAL  \n",
       "Yr_Mo_Dy                         \n",
       "1961-01-01  12.58  18.50  15.04  \n",
       "1961-01-02   9.67  17.54  13.83  \n",
       "1961-01-03   7.67  12.75  12.71  \n",
       "1961-01-04   5.88   5.46  10.88  \n",
       "1961-01-05  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# transform Yr_Mo_Dy it to date type datetime64\n",
    "data[\"Yr_Mo_Dy\"] = pd.to_datetime(data[\"Yr_Mo_Dy\"])\n",
    "\n",
    "# set 'Yr_Mo_Dy' as the index\n",
    "data = data.set_index('Yr_Mo_Dy')\n",
    "\n",
    "data.head()\n",
    "# data.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 6. Compute how many values are missing for each location over the entire record.  \n",
    "#### They should be ignored in all calculations below. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT    6\n",
       "VAL    3\n",
       "ROS    2\n",
       "KIL    5\n",
       "SHA    2\n",
       "BIR    0\n",
       "DUB    3\n",
       "CLA    2\n",
       "MUL    3\n",
       "CLO    1\n",
       "BEL    0\n",
       "MAL    4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# \"Number of non-missing values for each location: \"\n",
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 7. Compute how many non-missing values there are in total."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT    6568\n",
       "VAL    6571\n",
       "ROS    6572\n",
       "KIL    6569\n",
       "SHA    6572\n",
       "BIR    6574\n",
       "DUB    6571\n",
       "CLA    6572\n",
       "MUL    6571\n",
       "CLO    6573\n",
       "BEL    6574\n",
       "MAL    6570\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#number of columns minus the number of missing values for each location\n",
    "data.shape[0] - data.isnull().sum()\n",
    "\n",
    "#or\n",
    "\n",
    "data.notnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 8. Calculate the mean windspeeds of the windspeeds over all the locations and all the times.\n",
    "#### A single number for the entire dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10.227883764282167"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sum().sum() / data.notna().sum().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 9. Create a DataFrame called loc_stats and calculate the min, max and mean windspeeds and standard deviations of the windspeeds at each location over all the days \n",
    "\n",
    "#### A different set of numbers for each location."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>6568.000000</td>\n",
       "      <td>6571.000000</td>\n",
       "      <td>6572.000000</td>\n",
       "      <td>6569.000000</td>\n",
       "      <td>6572.000000</td>\n",
       "      <td>6574.000000</td>\n",
       "      <td>6571.000000</td>\n",
       "      <td>6572.000000</td>\n",
       "      <td>6571.000000</td>\n",
       "      <td>6573.000000</td>\n",
       "      <td>6574.000000</td>\n",
       "      <td>6570.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>12.362987</td>\n",
       "      <td>10.644314</td>\n",
       "      <td>11.660526</td>\n",
       "      <td>6.306468</td>\n",
       "      <td>10.455834</td>\n",
       "      <td>7.092254</td>\n",
       "      <td>9.797343</td>\n",
       "      <td>8.495053</td>\n",
       "      <td>8.493590</td>\n",
       "      <td>8.707332</td>\n",
       "      <td>13.121007</td>\n",
       "      <td>15.599079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.618413</td>\n",
       "      <td>5.267356</td>\n",
       "      <td>5.008450</td>\n",
       "      <td>3.605811</td>\n",
       "      <td>4.936125</td>\n",
       "      <td>3.968683</td>\n",
       "      <td>4.977555</td>\n",
       "      <td>4.499449</td>\n",
       "      <td>4.166872</td>\n",
       "      <td>4.503954</td>\n",
       "      <td>5.835037</td>\n",
       "      <td>6.699794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.670000</td>\n",
       "      <td>0.210000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.130000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.130000</td>\n",
       "      <td>0.670000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>11.710000</td>\n",
       "      <td>10.170000</td>\n",
       "      <td>10.920000</td>\n",
       "      <td>5.750000</td>\n",
       "      <td>9.960000</td>\n",
       "      <td>6.830000</td>\n",
       "      <td>9.210000</td>\n",
       "      <td>8.080000</td>\n",
       "      <td>8.170000</td>\n",
       "      <td>8.290000</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>15.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>35.800000</td>\n",
       "      <td>33.370000</td>\n",
       "      <td>33.840000</td>\n",
       "      <td>28.460000</td>\n",
       "      <td>37.540000</td>\n",
       "      <td>26.160000</td>\n",
       "      <td>30.370000</td>\n",
       "      <td>31.080000</td>\n",
       "      <td>25.880000</td>\n",
       "      <td>28.210000</td>\n",
       "      <td>42.380000</td>\n",
       "      <td>42.540000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               RPT          VAL          ROS          KIL          SHA  \\\n",
       "count  6568.000000  6571.000000  6572.000000  6569.000000  6572.000000   \n",
       "mean     12.362987    10.644314    11.660526     6.306468    10.455834   \n",
       "std       5.618413     5.267356     5.008450     3.605811     4.936125   \n",
       "min       0.670000     0.210000     1.500000     0.000000     0.130000   \n",
       "50%      11.710000    10.170000    10.920000     5.750000     9.960000   \n",
       "max      35.800000    33.370000    33.840000    28.460000    37.540000   \n",
       "\n",
       "               BIR          DUB          CLA          MUL          CLO  \\\n",
       "count  6574.000000  6571.000000  6572.000000  6571.000000  6573.000000   \n",
       "mean      7.092254     9.797343     8.495053     8.493590     8.707332   \n",
       "std       3.968683     4.977555     4.499449     4.166872     4.503954   \n",
       "min       0.000000     0.000000     0.000000     0.000000     0.040000   \n",
       "50%       6.830000     9.210000     8.080000     8.170000     8.290000   \n",
       "max      26.160000    30.370000    31.080000    25.880000    28.210000   \n",
       "\n",
       "               BEL          MAL  \n",
       "count  6574.000000  6570.000000  \n",
       "mean     13.121007    15.599079  \n",
       "std       5.835037     6.699794  \n",
       "min       0.130000     0.670000  \n",
       "50%      12.500000    15.000000  \n",
       "max      42.380000    42.540000  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe(percentiles=[])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 10. Create a DataFrame called day_stats and calculate the min, max and mean windspeed and standard deviations of the windspeeds across all the locations at each day.\n",
    "\n",
    "#### A different set of numbers for each day."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>9.29</td>\n",
       "      <td>18.50</td>\n",
       "      <td>13.018182</td>\n",
       "      <td>2.808875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02</th>\n",
       "      <td>6.50</td>\n",
       "      <td>17.54</td>\n",
       "      <td>11.336364</td>\n",
       "      <td>3.188994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-03</th>\n",
       "      <td>6.17</td>\n",
       "      <td>18.50</td>\n",
       "      <td>11.641818</td>\n",
       "      <td>3.681912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-04</th>\n",
       "      <td>1.79</td>\n",
       "      <td>11.75</td>\n",
       "      <td>6.619167</td>\n",
       "      <td>3.198126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-05</th>\n",
       "      <td>6.17</td>\n",
       "      <td>13.33</td>\n",
       "      <td>10.630000</td>\n",
       "      <td>2.445356</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             min    max       mean       std\n",
       "Yr_Mo_Dy                                    \n",
       "1961-01-01  9.29  18.50  13.018182  2.808875\n",
       "1961-01-02  6.50  17.54  11.336364  3.188994\n",
       "1961-01-03  6.17  18.50  11.641818  3.681912\n",
       "1961-01-04  1.79  11.75   6.619167  3.198126\n",
       "1961-01-05  6.17  13.33  10.630000  2.445356"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create the dataframe\n",
    "day_stats = pd.DataFrame()\n",
    "\n",
    "# this time we determine axis equals to one so it gets each row.\n",
    "day_stats['min'] = data.min(axis = 1) # min\n",
    "day_stats['max'] = data.max(axis = 1) # max \n",
    "day_stats['mean'] = data.mean(axis = 1) # mean\n",
    "day_stats['std'] = data.std(axis = 1) # standard deviations\n",
    "\n",
    "day_stats.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 11. Find the average windspeed in January for each location.  \n",
    "#### Treat January 1961 and January 1962 both as January."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT    14.847325\n",
       "VAL    12.914560\n",
       "ROS    13.299624\n",
       "KIL     7.199498\n",
       "SHA    11.667734\n",
       "BIR     8.054839\n",
       "DUB    11.819355\n",
       "CLA     9.512047\n",
       "MUL     9.543208\n",
       "CLO    10.053566\n",
       "BEL    14.550520\n",
       "MAL    18.028763\n",
       "dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data.index.month == 1].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 12. Downsample the record to a yearly frequency for each location."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961</th>\n",
       "      <td>12.299583</td>\n",
       "      <td>10.351796</td>\n",
       "      <td>11.362369</td>\n",
       "      <td>6.958227</td>\n",
       "      <td>10.881763</td>\n",
       "      <td>7.729726</td>\n",
       "      <td>9.733923</td>\n",
       "      <td>8.858788</td>\n",
       "      <td>8.647652</td>\n",
       "      <td>9.835577</td>\n",
       "      <td>13.502795</td>\n",
       "      <td>13.680773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962</th>\n",
       "      <td>12.246923</td>\n",
       "      <td>10.110438</td>\n",
       "      <td>11.732712</td>\n",
       "      <td>6.960440</td>\n",
       "      <td>10.657918</td>\n",
       "      <td>7.393068</td>\n",
       "      <td>11.020712</td>\n",
       "      <td>8.793753</td>\n",
       "      <td>8.316822</td>\n",
       "      <td>9.676247</td>\n",
       "      <td>12.930685</td>\n",
       "      <td>14.323956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963</th>\n",
       "      <td>12.813452</td>\n",
       "      <td>10.836986</td>\n",
       "      <td>12.541151</td>\n",
       "      <td>7.330055</td>\n",
       "      <td>11.724110</td>\n",
       "      <td>8.434712</td>\n",
       "      <td>11.075699</td>\n",
       "      <td>10.336548</td>\n",
       "      <td>8.903589</td>\n",
       "      <td>10.224438</td>\n",
       "      <td>13.638877</td>\n",
       "      <td>14.999014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1964</th>\n",
       "      <td>12.363661</td>\n",
       "      <td>10.920164</td>\n",
       "      <td>12.104372</td>\n",
       "      <td>6.787787</td>\n",
       "      <td>11.454481</td>\n",
       "      <td>7.570874</td>\n",
       "      <td>10.259153</td>\n",
       "      <td>9.467350</td>\n",
       "      <td>7.789016</td>\n",
       "      <td>10.207951</td>\n",
       "      <td>13.740546</td>\n",
       "      <td>14.910301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1965</th>\n",
       "      <td>12.451370</td>\n",
       "      <td>11.075534</td>\n",
       "      <td>11.848767</td>\n",
       "      <td>6.858466</td>\n",
       "      <td>11.024795</td>\n",
       "      <td>7.478110</td>\n",
       "      <td>10.618712</td>\n",
       "      <td>8.879918</td>\n",
       "      <td>7.907425</td>\n",
       "      <td>9.918082</td>\n",
       "      <td>12.964247</td>\n",
       "      <td>15.591644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1966</th>\n",
       "      <td>13.461973</td>\n",
       "      <td>11.557205</td>\n",
       "      <td>12.020630</td>\n",
       "      <td>7.345726</td>\n",
       "      <td>11.805041</td>\n",
       "      <td>7.793671</td>\n",
       "      <td>10.579808</td>\n",
       "      <td>8.835096</td>\n",
       "      <td>8.514438</td>\n",
       "      <td>9.768959</td>\n",
       "      <td>14.265836</td>\n",
       "      <td>16.307260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1967</th>\n",
       "      <td>12.737151</td>\n",
       "      <td>10.990986</td>\n",
       "      <td>11.739397</td>\n",
       "      <td>7.143425</td>\n",
       "      <td>11.630740</td>\n",
       "      <td>7.368164</td>\n",
       "      <td>10.652027</td>\n",
       "      <td>9.325616</td>\n",
       "      <td>8.645014</td>\n",
       "      <td>9.547425</td>\n",
       "      <td>14.774548</td>\n",
       "      <td>17.135945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1968</th>\n",
       "      <td>11.835628</td>\n",
       "      <td>10.468197</td>\n",
       "      <td>11.409754</td>\n",
       "      <td>6.477678</td>\n",
       "      <td>10.760765</td>\n",
       "      <td>6.067322</td>\n",
       "      <td>8.859180</td>\n",
       "      <td>8.255519</td>\n",
       "      <td>7.224945</td>\n",
       "      <td>7.832978</td>\n",
       "      <td>12.808634</td>\n",
       "      <td>15.017486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1969</th>\n",
       "      <td>11.166356</td>\n",
       "      <td>9.723699</td>\n",
       "      <td>10.902000</td>\n",
       "      <td>5.767973</td>\n",
       "      <td>9.873918</td>\n",
       "      <td>6.189973</td>\n",
       "      <td>8.564493</td>\n",
       "      <td>7.711397</td>\n",
       "      <td>7.924521</td>\n",
       "      <td>7.754384</td>\n",
       "      <td>12.621233</td>\n",
       "      <td>15.762904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970</th>\n",
       "      <td>12.600329</td>\n",
       "      <td>10.726932</td>\n",
       "      <td>11.730247</td>\n",
       "      <td>6.217178</td>\n",
       "      <td>10.567370</td>\n",
       "      <td>7.609452</td>\n",
       "      <td>9.609890</td>\n",
       "      <td>8.334630</td>\n",
       "      <td>9.297616</td>\n",
       "      <td>8.289808</td>\n",
       "      <td>13.183644</td>\n",
       "      <td>16.456027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1971</th>\n",
       "      <td>11.273123</td>\n",
       "      <td>9.095178</td>\n",
       "      <td>11.088329</td>\n",
       "      <td>5.241507</td>\n",
       "      <td>9.440329</td>\n",
       "      <td>6.097151</td>\n",
       "      <td>8.385890</td>\n",
       "      <td>6.757315</td>\n",
       "      <td>7.915370</td>\n",
       "      <td>7.229753</td>\n",
       "      <td>12.208932</td>\n",
       "      <td>15.025233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1972</th>\n",
       "      <td>12.463962</td>\n",
       "      <td>10.561311</td>\n",
       "      <td>12.058333</td>\n",
       "      <td>5.929699</td>\n",
       "      <td>9.430410</td>\n",
       "      <td>6.358825</td>\n",
       "      <td>9.704508</td>\n",
       "      <td>7.680792</td>\n",
       "      <td>8.357295</td>\n",
       "      <td>7.515273</td>\n",
       "      <td>12.727377</td>\n",
       "      <td>15.028716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1973</th>\n",
       "      <td>11.828466</td>\n",
       "      <td>10.680493</td>\n",
       "      <td>10.680493</td>\n",
       "      <td>5.547863</td>\n",
       "      <td>9.640877</td>\n",
       "      <td>6.548740</td>\n",
       "      <td>8.482110</td>\n",
       "      <td>7.614274</td>\n",
       "      <td>8.245534</td>\n",
       "      <td>7.812411</td>\n",
       "      <td>12.169699</td>\n",
       "      <td>15.441096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1974</th>\n",
       "      <td>13.643096</td>\n",
       "      <td>11.811781</td>\n",
       "      <td>12.336356</td>\n",
       "      <td>6.427041</td>\n",
       "      <td>11.110986</td>\n",
       "      <td>6.809781</td>\n",
       "      <td>10.084603</td>\n",
       "      <td>9.896986</td>\n",
       "      <td>9.331753</td>\n",
       "      <td>8.736356</td>\n",
       "      <td>13.252959</td>\n",
       "      <td>16.947671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1975</th>\n",
       "      <td>12.008575</td>\n",
       "      <td>10.293836</td>\n",
       "      <td>11.564712</td>\n",
       "      <td>5.269096</td>\n",
       "      <td>9.190082</td>\n",
       "      <td>5.668521</td>\n",
       "      <td>8.562603</td>\n",
       "      <td>7.843836</td>\n",
       "      <td>8.797945</td>\n",
       "      <td>7.382822</td>\n",
       "      <td>12.631671</td>\n",
       "      <td>15.307863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976</th>\n",
       "      <td>11.737842</td>\n",
       "      <td>10.203115</td>\n",
       "      <td>10.761230</td>\n",
       "      <td>5.109426</td>\n",
       "      <td>8.846339</td>\n",
       "      <td>6.311038</td>\n",
       "      <td>9.149126</td>\n",
       "      <td>7.146202</td>\n",
       "      <td>8.883716</td>\n",
       "      <td>7.883087</td>\n",
       "      <td>12.332377</td>\n",
       "      <td>15.471448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977</th>\n",
       "      <td>13.099616</td>\n",
       "      <td>11.144493</td>\n",
       "      <td>12.627836</td>\n",
       "      <td>6.073945</td>\n",
       "      <td>10.003836</td>\n",
       "      <td>8.586438</td>\n",
       "      <td>11.523205</td>\n",
       "      <td>8.378384</td>\n",
       "      <td>9.098192</td>\n",
       "      <td>8.821616</td>\n",
       "      <td>13.459068</td>\n",
       "      <td>16.590849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978</th>\n",
       "      <td>12.504356</td>\n",
       "      <td>11.044274</td>\n",
       "      <td>11.380000</td>\n",
       "      <td>6.082356</td>\n",
       "      <td>10.167233</td>\n",
       "      <td>7.650658</td>\n",
       "      <td>9.489342</td>\n",
       "      <td>8.800466</td>\n",
       "      <td>9.089753</td>\n",
       "      <td>8.301699</td>\n",
       "      <td>12.967397</td>\n",
       "      <td>16.771370</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                RPT        VAL        ROS       KIL        SHA       BIR  \\\n",
       "Yr_Mo_Dy                                                                   \n",
       "1961      12.299583  10.351796  11.362369  6.958227  10.881763  7.729726   \n",
       "1962      12.246923  10.110438  11.732712  6.960440  10.657918  7.393068   \n",
       "1963      12.813452  10.836986  12.541151  7.330055  11.724110  8.434712   \n",
       "1964      12.363661  10.920164  12.104372  6.787787  11.454481  7.570874   \n",
       "1965      12.451370  11.075534  11.848767  6.858466  11.024795  7.478110   \n",
       "1966      13.461973  11.557205  12.020630  7.345726  11.805041  7.793671   \n",
       "1967      12.737151  10.990986  11.739397  7.143425  11.630740  7.368164   \n",
       "1968      11.835628  10.468197  11.409754  6.477678  10.760765  6.067322   \n",
       "1969      11.166356   9.723699  10.902000  5.767973   9.873918  6.189973   \n",
       "1970      12.600329  10.726932  11.730247  6.217178  10.567370  7.609452   \n",
       "1971      11.273123   9.095178  11.088329  5.241507   9.440329  6.097151   \n",
       "1972      12.463962  10.561311  12.058333  5.929699   9.430410  6.358825   \n",
       "1973      11.828466  10.680493  10.680493  5.547863   9.640877  6.548740   \n",
       "1974      13.643096  11.811781  12.336356  6.427041  11.110986  6.809781   \n",
       "1975      12.008575  10.293836  11.564712  5.269096   9.190082  5.668521   \n",
       "1976      11.737842  10.203115  10.761230  5.109426   8.846339  6.311038   \n",
       "1977      13.099616  11.144493  12.627836  6.073945  10.003836  8.586438   \n",
       "1978      12.504356  11.044274  11.380000  6.082356  10.167233  7.650658   \n",
       "\n",
       "                DUB        CLA       MUL        CLO        BEL        MAL  \n",
       "Yr_Mo_Dy                                                                   \n",
       "1961       9.733923   8.858788  8.647652   9.835577  13.502795  13.680773  \n",
       "1962      11.020712   8.793753  8.316822   9.676247  12.930685  14.323956  \n",
       "1963      11.075699  10.336548  8.903589  10.224438  13.638877  14.999014  \n",
       "1964      10.259153   9.467350  7.789016  10.207951  13.740546  14.910301  \n",
       "1965      10.618712   8.879918  7.907425   9.918082  12.964247  15.591644  \n",
       "1966      10.579808   8.835096  8.514438   9.768959  14.265836  16.307260  \n",
       "1967      10.652027   9.325616  8.645014   9.547425  14.774548  17.135945  \n",
       "1968       8.859180   8.255519  7.224945   7.832978  12.808634  15.017486  \n",
       "1969       8.564493   7.711397  7.924521   7.754384  12.621233  15.762904  \n",
       "1970       9.609890   8.334630  9.297616   8.289808  13.183644  16.456027  \n",
       "1971       8.385890   6.757315  7.915370   7.229753  12.208932  15.025233  \n",
       "1972       9.704508   7.680792  8.357295   7.515273  12.727377  15.028716  \n",
       "1973       8.482110   7.614274  8.245534   7.812411  12.169699  15.441096  \n",
       "1974      10.084603   9.896986  9.331753   8.736356  13.252959  16.947671  \n",
       "1975       8.562603   7.843836  8.797945   7.382822  12.631671  15.307863  \n",
       "1976       9.149126   7.146202  8.883716   7.883087  12.332377  15.471448  \n",
       "1977      11.523205   8.378384  9.098192   8.821616  13.459068  16.590849  \n",
       "1978       9.489342   8.800466  9.089753   8.301699  12.967397  16.771370  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(data.index.to_period('A')).mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 13. Downsample the record to a monthly frequency for each location."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01</th>\n",
       "      <td>14.841333</td>\n",
       "      <td>11.988333</td>\n",
       "      <td>13.431613</td>\n",
       "      <td>7.736774</td>\n",
       "      <td>11.072759</td>\n",
       "      <td>8.588065</td>\n",
       "      <td>11.184839</td>\n",
       "      <td>9.245333</td>\n",
       "      <td>9.085806</td>\n",
       "      <td>10.107419</td>\n",
       "      <td>13.880968</td>\n",
       "      <td>14.703226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02</th>\n",
       "      <td>16.269286</td>\n",
       "      <td>14.975357</td>\n",
       "      <td>14.441481</td>\n",
       "      <td>9.230741</td>\n",
       "      <td>13.852143</td>\n",
       "      <td>10.937500</td>\n",
       "      <td>11.890714</td>\n",
       "      <td>11.846071</td>\n",
       "      <td>11.821429</td>\n",
       "      <td>12.714286</td>\n",
       "      <td>18.583214</td>\n",
       "      <td>15.411786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03</th>\n",
       "      <td>10.890000</td>\n",
       "      <td>11.296452</td>\n",
       "      <td>10.752903</td>\n",
       "      <td>7.284000</td>\n",
       "      <td>10.509355</td>\n",
       "      <td>8.866774</td>\n",
       "      <td>9.644194</td>\n",
       "      <td>9.829677</td>\n",
       "      <td>10.294138</td>\n",
       "      <td>11.251935</td>\n",
       "      <td>16.410968</td>\n",
       "      <td>15.720000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04</th>\n",
       "      <td>10.722667</td>\n",
       "      <td>9.427667</td>\n",
       "      <td>9.998000</td>\n",
       "      <td>5.830667</td>\n",
       "      <td>8.435000</td>\n",
       "      <td>6.495000</td>\n",
       "      <td>6.925333</td>\n",
       "      <td>7.094667</td>\n",
       "      <td>7.342333</td>\n",
       "      <td>7.237000</td>\n",
       "      <td>11.147333</td>\n",
       "      <td>10.278333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05</th>\n",
       "      <td>9.860968</td>\n",
       "      <td>8.850000</td>\n",
       "      <td>10.818065</td>\n",
       "      <td>5.905333</td>\n",
       "      <td>9.490323</td>\n",
       "      <td>6.574839</td>\n",
       "      <td>7.604000</td>\n",
       "      <td>8.177097</td>\n",
       "      <td>8.039355</td>\n",
       "      <td>8.499355</td>\n",
       "      <td>11.900323</td>\n",
       "      <td>12.011613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06</th>\n",
       "      <td>9.904138</td>\n",
       "      <td>8.520333</td>\n",
       "      <td>8.867000</td>\n",
       "      <td>6.083000</td>\n",
       "      <td>10.824000</td>\n",
       "      <td>6.707333</td>\n",
       "      <td>9.095667</td>\n",
       "      <td>8.849333</td>\n",
       "      <td>9.086667</td>\n",
       "      <td>9.940333</td>\n",
       "      <td>13.995000</td>\n",
       "      <td>14.553793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-07</th>\n",
       "      <td>10.614194</td>\n",
       "      <td>8.221613</td>\n",
       "      <td>9.110323</td>\n",
       "      <td>6.340968</td>\n",
       "      <td>10.532581</td>\n",
       "      <td>6.198387</td>\n",
       "      <td>8.353333</td>\n",
       "      <td>8.284194</td>\n",
       "      <td>8.077097</td>\n",
       "      <td>8.891613</td>\n",
       "      <td>11.092581</td>\n",
       "      <td>12.312903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-08</th>\n",
       "      <td>12.035000</td>\n",
       "      <td>10.133871</td>\n",
       "      <td>10.335806</td>\n",
       "      <td>6.845806</td>\n",
       "      <td>12.715161</td>\n",
       "      <td>8.441935</td>\n",
       "      <td>10.093871</td>\n",
       "      <td>10.460968</td>\n",
       "      <td>9.111613</td>\n",
       "      <td>10.544667</td>\n",
       "      <td>14.410000</td>\n",
       "      <td>14.345333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-09</th>\n",
       "      <td>12.531000</td>\n",
       "      <td>9.656897</td>\n",
       "      <td>10.776897</td>\n",
       "      <td>7.155517</td>\n",
       "      <td>11.003333</td>\n",
       "      <td>7.234000</td>\n",
       "      <td>8.206000</td>\n",
       "      <td>8.936552</td>\n",
       "      <td>7.728333</td>\n",
       "      <td>9.931333</td>\n",
       "      <td>13.718333</td>\n",
       "      <td>12.921667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-10</th>\n",
       "      <td>14.289667</td>\n",
       "      <td>10.915806</td>\n",
       "      <td>12.236452</td>\n",
       "      <td>8.154839</td>\n",
       "      <td>11.865484</td>\n",
       "      <td>8.333871</td>\n",
       "      <td>11.194194</td>\n",
       "      <td>9.271935</td>\n",
       "      <td>8.942667</td>\n",
       "      <td>11.455806</td>\n",
       "      <td>14.229355</td>\n",
       "      <td>16.793226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-11</th>\n",
       "      <td>10.896333</td>\n",
       "      <td>8.592667</td>\n",
       "      <td>11.850333</td>\n",
       "      <td>6.045667</td>\n",
       "      <td>9.123667</td>\n",
       "      <td>6.250667</td>\n",
       "      <td>10.869655</td>\n",
       "      <td>6.313667</td>\n",
       "      <td>6.575000</td>\n",
       "      <td>8.383667</td>\n",
       "      <td>10.776667</td>\n",
       "      <td>12.146000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-12</th>\n",
       "      <td>14.973548</td>\n",
       "      <td>11.903871</td>\n",
       "      <td>13.980323</td>\n",
       "      <td>7.073871</td>\n",
       "      <td>11.323548</td>\n",
       "      <td>8.302258</td>\n",
       "      <td>11.753548</td>\n",
       "      <td>8.163226</td>\n",
       "      <td>7.965806</td>\n",
       "      <td>9.246774</td>\n",
       "      <td>12.239355</td>\n",
       "      <td>13.098710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01</th>\n",
       "      <td>14.783871</td>\n",
       "      <td>13.160323</td>\n",
       "      <td>12.591935</td>\n",
       "      <td>7.538065</td>\n",
       "      <td>11.779677</td>\n",
       "      <td>8.720000</td>\n",
       "      <td>14.211935</td>\n",
       "      <td>9.600000</td>\n",
       "      <td>9.670000</td>\n",
       "      <td>11.498710</td>\n",
       "      <td>16.369355</td>\n",
       "      <td>15.661613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-02</th>\n",
       "      <td>15.844643</td>\n",
       "      <td>12.041429</td>\n",
       "      <td>15.178929</td>\n",
       "      <td>9.262963</td>\n",
       "      <td>13.821429</td>\n",
       "      <td>9.726786</td>\n",
       "      <td>16.916429</td>\n",
       "      <td>11.285357</td>\n",
       "      <td>12.021071</td>\n",
       "      <td>12.126429</td>\n",
       "      <td>16.705357</td>\n",
       "      <td>18.426786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-03</th>\n",
       "      <td>11.634333</td>\n",
       "      <td>8.602258</td>\n",
       "      <td>12.110645</td>\n",
       "      <td>6.403226</td>\n",
       "      <td>10.352258</td>\n",
       "      <td>6.732258</td>\n",
       "      <td>10.223226</td>\n",
       "      <td>7.641935</td>\n",
       "      <td>7.092258</td>\n",
       "      <td>8.052581</td>\n",
       "      <td>9.690000</td>\n",
       "      <td>11.509000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-04</th>\n",
       "      <td>12.160667</td>\n",
       "      <td>9.676667</td>\n",
       "      <td>12.088333</td>\n",
       "      <td>7.163000</td>\n",
       "      <td>10.544000</td>\n",
       "      <td>7.558000</td>\n",
       "      <td>11.480000</td>\n",
       "      <td>8.722000</td>\n",
       "      <td>8.703667</td>\n",
       "      <td>9.311667</td>\n",
       "      <td>12.234333</td>\n",
       "      <td>11.780667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-05</th>\n",
       "      <td>12.745806</td>\n",
       "      <td>10.865484</td>\n",
       "      <td>11.874839</td>\n",
       "      <td>7.471935</td>\n",
       "      <td>11.285806</td>\n",
       "      <td>7.209032</td>\n",
       "      <td>10.105806</td>\n",
       "      <td>9.084516</td>\n",
       "      <td>7.868065</td>\n",
       "      <td>9.293226</td>\n",
       "      <td>12.130000</td>\n",
       "      <td>12.922581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-06</th>\n",
       "      <td>10.305667</td>\n",
       "      <td>9.677000</td>\n",
       "      <td>9.996333</td>\n",
       "      <td>6.846667</td>\n",
       "      <td>10.711333</td>\n",
       "      <td>7.441333</td>\n",
       "      <td>10.548667</td>\n",
       "      <td>10.306667</td>\n",
       "      <td>9.196000</td>\n",
       "      <td>10.520333</td>\n",
       "      <td>13.757000</td>\n",
       "      <td>15.218333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-07</th>\n",
       "      <td>9.981935</td>\n",
       "      <td>8.370645</td>\n",
       "      <td>9.753548</td>\n",
       "      <td>6.093226</td>\n",
       "      <td>9.112903</td>\n",
       "      <td>5.877097</td>\n",
       "      <td>7.781613</td>\n",
       "      <td>8.123226</td>\n",
       "      <td>6.829677</td>\n",
       "      <td>8.613226</td>\n",
       "      <td>10.783871</td>\n",
       "      <td>11.326129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-08</th>\n",
       "      <td>10.964194</td>\n",
       "      <td>9.694194</td>\n",
       "      <td>10.184516</td>\n",
       "      <td>6.701290</td>\n",
       "      <td>10.465161</td>\n",
       "      <td>7.009032</td>\n",
       "      <td>11.136774</td>\n",
       "      <td>9.097419</td>\n",
       "      <td>8.645484</td>\n",
       "      <td>9.511613</td>\n",
       "      <td>13.119032</td>\n",
       "      <td>15.420968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-09</th>\n",
       "      <td>11.176333</td>\n",
       "      <td>9.507000</td>\n",
       "      <td>11.640000</td>\n",
       "      <td>6.164333</td>\n",
       "      <td>9.722333</td>\n",
       "      <td>6.214000</td>\n",
       "      <td>8.488000</td>\n",
       "      <td>7.020333</td>\n",
       "      <td>6.372667</td>\n",
       "      <td>8.286000</td>\n",
       "      <td>11.483667</td>\n",
       "      <td>12.313333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10</th>\n",
       "      <td>9.699355</td>\n",
       "      <td>8.063548</td>\n",
       "      <td>9.357097</td>\n",
       "      <td>4.818065</td>\n",
       "      <td>8.432258</td>\n",
       "      <td>5.730000</td>\n",
       "      <td>8.448065</td>\n",
       "      <td>7.626774</td>\n",
       "      <td>6.630645</td>\n",
       "      <td>9.091290</td>\n",
       "      <td>13.286774</td>\n",
       "      <td>14.090323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-11</th>\n",
       "      <td>11.071333</td>\n",
       "      <td>7.984000</td>\n",
       "      <td>12.035667</td>\n",
       "      <td>5.740000</td>\n",
       "      <td>8.135667</td>\n",
       "      <td>6.338333</td>\n",
       "      <td>9.615333</td>\n",
       "      <td>5.943000</td>\n",
       "      <td>6.362333</td>\n",
       "      <td>8.084333</td>\n",
       "      <td>9.786667</td>\n",
       "      <td>13.298333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-12</th>\n",
       "      <td>16.785484</td>\n",
       "      <td>13.753548</td>\n",
       "      <td>14.276452</td>\n",
       "      <td>9.557419</td>\n",
       "      <td>13.724839</td>\n",
       "      <td>10.321613</td>\n",
       "      <td>13.735806</td>\n",
       "      <td>11.212258</td>\n",
       "      <td>10.683548</td>\n",
       "      <td>11.881935</td>\n",
       "      <td>16.043548</td>\n",
       "      <td>20.074516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-01</th>\n",
       "      <td>14.868387</td>\n",
       "      <td>11.112903</td>\n",
       "      <td>15.121613</td>\n",
       "      <td>6.635806</td>\n",
       "      <td>11.080645</td>\n",
       "      <td>7.835484</td>\n",
       "      <td>12.797419</td>\n",
       "      <td>9.844839</td>\n",
       "      <td>7.841613</td>\n",
       "      <td>9.390000</td>\n",
       "      <td>11.428710</td>\n",
       "      <td>18.822258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-02</th>\n",
       "      <td>14.418929</td>\n",
       "      <td>11.876429</td>\n",
       "      <td>15.697500</td>\n",
       "      <td>8.611786</td>\n",
       "      <td>12.887857</td>\n",
       "      <td>9.600357</td>\n",
       "      <td>12.729286</td>\n",
       "      <td>10.823214</td>\n",
       "      <td>8.981786</td>\n",
       "      <td>10.355714</td>\n",
       "      <td>13.266429</td>\n",
       "      <td>17.120714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-03</th>\n",
       "      <td>14.853871</td>\n",
       "      <td>12.271290</td>\n",
       "      <td>14.295806</td>\n",
       "      <td>9.268387</td>\n",
       "      <td>13.112903</td>\n",
       "      <td>10.088065</td>\n",
       "      <td>12.168387</td>\n",
       "      <td>11.340968</td>\n",
       "      <td>9.690968</td>\n",
       "      <td>11.515484</td>\n",
       "      <td>13.982903</td>\n",
       "      <td>14.132581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-04</th>\n",
       "      <td>11.616000</td>\n",
       "      <td>10.138000</td>\n",
       "      <td>13.233667</td>\n",
       "      <td>7.990333</td>\n",
       "      <td>11.515333</td>\n",
       "      <td>9.727000</td>\n",
       "      <td>11.979000</td>\n",
       "      <td>11.353000</td>\n",
       "      <td>10.341667</td>\n",
       "      <td>11.900333</td>\n",
       "      <td>13.875667</td>\n",
       "      <td>16.333667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-05</th>\n",
       "      <td>12.879677</td>\n",
       "      <td>11.010645</td>\n",
       "      <td>12.881290</td>\n",
       "      <td>8.411613</td>\n",
       "      <td>12.981613</td>\n",
       "      <td>9.739677</td>\n",
       "      <td>12.280968</td>\n",
       "      <td>10.964194</td>\n",
       "      <td>10.745161</td>\n",
       "      <td>11.394839</td>\n",
       "      <td>14.777097</td>\n",
       "      <td>14.975161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-06</th>\n",
       "      <td>10.623333</td>\n",
       "      <td>8.434667</td>\n",
       "      <td>11.685000</td>\n",
       "      <td>6.420333</td>\n",
       "      <td>10.142667</td>\n",
       "      <td>7.219333</td>\n",
       "      <td>9.267333</td>\n",
       "      <td>9.589333</td>\n",
       "      <td>8.583667</td>\n",
       "      <td>9.585333</td>\n",
       "      <td>12.098000</td>\n",
       "      <td>11.358667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-07</th>\n",
       "      <td>9.687742</td>\n",
       "      <td>7.980968</td>\n",
       "      <td>8.267742</td>\n",
       "      <td>4.631613</td>\n",
       "      <td>7.576774</td>\n",
       "      <td>4.927419</td>\n",
       "      <td>6.994839</td>\n",
       "      <td>5.135806</td>\n",
       "      <td>7.941290</td>\n",
       "      <td>6.491290</td>\n",
       "      <td>10.264194</td>\n",
       "      <td>11.912258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-08</th>\n",
       "      <td>7.640645</td>\n",
       "      <td>5.366129</td>\n",
       "      <td>9.000645</td>\n",
       "      <td>3.142258</td>\n",
       "      <td>4.695484</td>\n",
       "      <td>3.847742</td>\n",
       "      <td>5.437097</td>\n",
       "      <td>3.362581</td>\n",
       "      <td>5.946452</td>\n",
       "      <td>4.496452</td>\n",
       "      <td>7.079677</td>\n",
       "      <td>9.438387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-09</th>\n",
       "      <td>11.703667</td>\n",
       "      <td>10.515333</td>\n",
       "      <td>10.466333</td>\n",
       "      <td>5.313333</td>\n",
       "      <td>8.761333</td>\n",
       "      <td>7.062333</td>\n",
       "      <td>8.617667</td>\n",
       "      <td>6.415333</td>\n",
       "      <td>8.953333</td>\n",
       "      <td>7.263333</td>\n",
       "      <td>11.587000</td>\n",
       "      <td>17.634000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-10</th>\n",
       "      <td>12.427097</td>\n",
       "      <td>9.572258</td>\n",
       "      <td>10.640000</td>\n",
       "      <td>4.885484</td>\n",
       "      <td>9.393548</td>\n",
       "      <td>6.906452</td>\n",
       "      <td>6.380323</td>\n",
       "      <td>6.933226</td>\n",
       "      <td>7.552258</td>\n",
       "      <td>7.449032</td>\n",
       "      <td>11.837742</td>\n",
       "      <td>15.078065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-11</th>\n",
       "      <td>10.962667</td>\n",
       "      <td>9.443667</td>\n",
       "      <td>9.202000</td>\n",
       "      <td>3.696000</td>\n",
       "      <td>7.459333</td>\n",
       "      <td>7.026333</td>\n",
       "      <td>9.058333</td>\n",
       "      <td>5.791000</td>\n",
       "      <td>6.577000</td>\n",
       "      <td>7.512333</td>\n",
       "      <td>12.568333</td>\n",
       "      <td>15.685333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-12</th>\n",
       "      <td>11.962258</td>\n",
       "      <td>10.086774</td>\n",
       "      <td>10.474516</td>\n",
       "      <td>3.383871</td>\n",
       "      <td>7.645484</td>\n",
       "      <td>6.148387</td>\n",
       "      <td>8.034516</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>5.952258</td>\n",
       "      <td>6.147742</td>\n",
       "      <td>7.814839</td>\n",
       "      <td>14.346774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-01</th>\n",
       "      <td>13.404516</td>\n",
       "      <td>10.377742</td>\n",
       "      <td>12.764839</td>\n",
       "      <td>5.884516</td>\n",
       "      <td>9.159677</td>\n",
       "      <td>8.005161</td>\n",
       "      <td>10.107419</td>\n",
       "      <td>7.211613</td>\n",
       "      <td>8.280000</td>\n",
       "      <td>9.328387</td>\n",
       "      <td>12.131935</td>\n",
       "      <td>18.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-02</th>\n",
       "      <td>12.336786</td>\n",
       "      <td>11.898929</td>\n",
       "      <td>12.016786</td>\n",
       "      <td>5.317500</td>\n",
       "      <td>10.134643</td>\n",
       "      <td>9.423929</td>\n",
       "      <td>10.949643</td>\n",
       "      <td>7.965357</td>\n",
       "      <td>9.320000</td>\n",
       "      <td>8.711429</td>\n",
       "      <td>11.435357</td>\n",
       "      <td>17.561429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-03</th>\n",
       "      <td>16.750000</td>\n",
       "      <td>14.499677</td>\n",
       "      <td>16.118387</td>\n",
       "      <td>8.414516</td>\n",
       "      <td>13.293871</td>\n",
       "      <td>11.562258</td>\n",
       "      <td>14.283226</td>\n",
       "      <td>11.361613</td>\n",
       "      <td>12.102581</td>\n",
       "      <td>11.906452</td>\n",
       "      <td>15.863226</td>\n",
       "      <td>19.133548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-04</th>\n",
       "      <td>14.955333</td>\n",
       "      <td>12.293000</td>\n",
       "      <td>12.689667</td>\n",
       "      <td>7.422333</td>\n",
       "      <td>11.740000</td>\n",
       "      <td>10.137000</td>\n",
       "      <td>13.887667</td>\n",
       "      <td>9.574000</td>\n",
       "      <td>10.342333</td>\n",
       "      <td>11.419667</td>\n",
       "      <td>15.593667</td>\n",
       "      <td>18.274667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-05</th>\n",
       "      <td>9.441290</td>\n",
       "      <td>7.173871</td>\n",
       "      <td>12.455806</td>\n",
       "      <td>4.507742</td>\n",
       "      <td>6.198387</td>\n",
       "      <td>6.689677</td>\n",
       "      <td>9.226452</td>\n",
       "      <td>5.638387</td>\n",
       "      <td>6.699355</td>\n",
       "      <td>6.045484</td>\n",
       "      <td>10.213548</td>\n",
       "      <td>11.936129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-06</th>\n",
       "      <td>11.040000</td>\n",
       "      <td>8.353000</td>\n",
       "      <td>12.228000</td>\n",
       "      <td>4.864000</td>\n",
       "      <td>8.790333</td>\n",
       "      <td>7.209667</td>\n",
       "      <td>8.799667</td>\n",
       "      <td>5.931000</td>\n",
       "      <td>7.065333</td>\n",
       "      <td>6.583333</td>\n",
       "      <td>11.321333</td>\n",
       "      <td>11.175333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-07</th>\n",
       "      <td>10.881935</td>\n",
       "      <td>8.663548</td>\n",
       "      <td>10.816452</td>\n",
       "      <td>5.419677</td>\n",
       "      <td>9.014839</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>9.961935</td>\n",
       "      <td>6.526129</td>\n",
       "      <td>7.980968</td>\n",
       "      <td>7.620000</td>\n",
       "      <td>12.924194</td>\n",
       "      <td>12.186774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-08</th>\n",
       "      <td>9.233548</td>\n",
       "      <td>7.727742</td>\n",
       "      <td>10.679032</td>\n",
       "      <td>4.453871</td>\n",
       "      <td>6.620645</td>\n",
       "      <td>5.961290</td>\n",
       "      <td>8.943548</td>\n",
       "      <td>4.543226</td>\n",
       "      <td>6.384839</td>\n",
       "      <td>5.694839</td>\n",
       "      <td>9.825161</td>\n",
       "      <td>11.659355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-09</th>\n",
       "      <td>12.472333</td>\n",
       "      <td>10.742667</td>\n",
       "      <td>11.849333</td>\n",
       "      <td>5.638667</td>\n",
       "      <td>10.077333</td>\n",
       "      <td>8.242667</td>\n",
       "      <td>11.939333</td>\n",
       "      <td>7.923000</td>\n",
       "      <td>8.828000</td>\n",
       "      <td>8.506333</td>\n",
       "      <td>14.051000</td>\n",
       "      <td>17.030333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-10</th>\n",
       "      <td>15.004516</td>\n",
       "      <td>13.960000</td>\n",
       "      <td>12.819677</td>\n",
       "      <td>6.754194</td>\n",
       "      <td>11.779032</td>\n",
       "      <td>9.671613</td>\n",
       "      <td>12.924839</td>\n",
       "      <td>11.875161</td>\n",
       "      <td>11.481290</td>\n",
       "      <td>10.340323</td>\n",
       "      <td>17.640968</td>\n",
       "      <td>19.842903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-11</th>\n",
       "      <td>16.946667</td>\n",
       "      <td>15.444667</td>\n",
       "      <td>13.561333</td>\n",
       "      <td>7.584000</td>\n",
       "      <td>12.088667</td>\n",
       "      <td>9.161333</td>\n",
       "      <td>14.051000</td>\n",
       "      <td>11.286000</td>\n",
       "      <td>10.318667</td>\n",
       "      <td>10.327000</td>\n",
       "      <td>17.215333</td>\n",
       "      <td>22.333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-12</th>\n",
       "      <td>14.751935</td>\n",
       "      <td>12.744839</td>\n",
       "      <td>13.469677</td>\n",
       "      <td>6.592258</td>\n",
       "      <td>11.247742</td>\n",
       "      <td>9.466774</td>\n",
       "      <td>13.231613</td>\n",
       "      <td>10.703871</td>\n",
       "      <td>10.401613</td>\n",
       "      <td>9.415484</td>\n",
       "      <td>13.237419</td>\n",
       "      <td>19.299677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-01</th>\n",
       "      <td>14.291935</td>\n",
       "      <td>11.872258</td>\n",
       "      <td>12.014194</td>\n",
       "      <td>6.463226</td>\n",
       "      <td>11.402903</td>\n",
       "      <td>7.517097</td>\n",
       "      <td>12.207097</td>\n",
       "      <td>10.206452</td>\n",
       "      <td>9.549032</td>\n",
       "      <td>9.247419</td>\n",
       "      <td>15.101613</td>\n",
       "      <td>20.715806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-02</th>\n",
       "      <td>14.143571</td>\n",
       "      <td>12.153214</td>\n",
       "      <td>13.803214</td>\n",
       "      <td>6.828929</td>\n",
       "      <td>11.196786</td>\n",
       "      <td>7.858929</td>\n",
       "      <td>11.903214</td>\n",
       "      <td>11.068929</td>\n",
       "      <td>10.052143</td>\n",
       "      <td>8.093929</td>\n",
       "      <td>10.353929</td>\n",
       "      <td>17.298571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-03</th>\n",
       "      <td>14.717097</td>\n",
       "      <td>14.601935</td>\n",
       "      <td>13.334194</td>\n",
       "      <td>8.231290</td>\n",
       "      <td>12.783226</td>\n",
       "      <td>9.488710</td>\n",
       "      <td>12.129355</td>\n",
       "      <td>11.665161</td>\n",
       "      <td>11.656452</td>\n",
       "      <td>9.657097</td>\n",
       "      <td>14.234194</td>\n",
       "      <td>18.611290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-04</th>\n",
       "      <td>11.805000</td>\n",
       "      <td>11.255667</td>\n",
       "      <td>12.516333</td>\n",
       "      <td>5.920333</td>\n",
       "      <td>10.218000</td>\n",
       "      <td>7.301667</td>\n",
       "      <td>8.586333</td>\n",
       "      <td>8.306667</td>\n",
       "      <td>8.537000</td>\n",
       "      <td>6.999000</td>\n",
       "      <td>11.190667</td>\n",
       "      <td>14.152000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-05</th>\n",
       "      <td>8.270645</td>\n",
       "      <td>7.226774</td>\n",
       "      <td>6.901613</td>\n",
       "      <td>3.740645</td>\n",
       "      <td>6.973871</td>\n",
       "      <td>4.449677</td>\n",
       "      <td>5.420968</td>\n",
       "      <td>6.130645</td>\n",
       "      <td>5.742581</td>\n",
       "      <td>5.926452</td>\n",
       "      <td>9.263548</td>\n",
       "      <td>10.756452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06</th>\n",
       "      <td>11.386667</td>\n",
       "      <td>9.474333</td>\n",
       "      <td>10.253333</td>\n",
       "      <td>6.053000</td>\n",
       "      <td>10.395333</td>\n",
       "      <td>7.490333</td>\n",
       "      <td>7.928000</td>\n",
       "      <td>7.802000</td>\n",
       "      <td>8.220333</td>\n",
       "      <td>7.550000</td>\n",
       "      <td>11.501000</td>\n",
       "      <td>15.078667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07</th>\n",
       "      <td>12.820000</td>\n",
       "      <td>9.750968</td>\n",
       "      <td>9.910323</td>\n",
       "      <td>6.483871</td>\n",
       "      <td>10.055161</td>\n",
       "      <td>7.820645</td>\n",
       "      <td>7.831935</td>\n",
       "      <td>8.459355</td>\n",
       "      <td>8.523871</td>\n",
       "      <td>7.732903</td>\n",
       "      <td>12.648710</td>\n",
       "      <td>14.077419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08</th>\n",
       "      <td>9.645161</td>\n",
       "      <td>8.259355</td>\n",
       "      <td>9.032258</td>\n",
       "      <td>4.502903</td>\n",
       "      <td>7.368065</td>\n",
       "      <td>5.935161</td>\n",
       "      <td>5.650323</td>\n",
       "      <td>5.417742</td>\n",
       "      <td>7.241290</td>\n",
       "      <td>5.536774</td>\n",
       "      <td>10.466774</td>\n",
       "      <td>12.054194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09</th>\n",
       "      <td>10.913667</td>\n",
       "      <td>10.895000</td>\n",
       "      <td>10.635000</td>\n",
       "      <td>5.725000</td>\n",
       "      <td>10.372000</td>\n",
       "      <td>9.278333</td>\n",
       "      <td>10.790333</td>\n",
       "      <td>9.583000</td>\n",
       "      <td>10.069333</td>\n",
       "      <td>8.939000</td>\n",
       "      <td>15.680333</td>\n",
       "      <td>19.391333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10</th>\n",
       "      <td>9.897742</td>\n",
       "      <td>8.670968</td>\n",
       "      <td>9.295806</td>\n",
       "      <td>4.721290</td>\n",
       "      <td>8.525161</td>\n",
       "      <td>6.774194</td>\n",
       "      <td>8.115484</td>\n",
       "      <td>7.337742</td>\n",
       "      <td>8.297742</td>\n",
       "      <td>8.243871</td>\n",
       "      <td>13.776774</td>\n",
       "      <td>17.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11</th>\n",
       "      <td>16.151667</td>\n",
       "      <td>14.802667</td>\n",
       "      <td>13.508000</td>\n",
       "      <td>7.317333</td>\n",
       "      <td>11.475000</td>\n",
       "      <td>8.743000</td>\n",
       "      <td>11.492333</td>\n",
       "      <td>9.657333</td>\n",
       "      <td>10.701333</td>\n",
       "      <td>10.676000</td>\n",
       "      <td>17.404667</td>\n",
       "      <td>20.723000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12</th>\n",
       "      <td>16.175484</td>\n",
       "      <td>13.748065</td>\n",
       "      <td>15.635161</td>\n",
       "      <td>7.094839</td>\n",
       "      <td>11.398710</td>\n",
       "      <td>9.241613</td>\n",
       "      <td>12.077419</td>\n",
       "      <td>10.194839</td>\n",
       "      <td>10.616774</td>\n",
       "      <td>11.028710</td>\n",
       "      <td>13.859677</td>\n",
       "      <td>21.371613</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>216 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                RPT        VAL        ROS       KIL        SHA        BIR  \\\n",
       "Yr_Mo_Dy                                                                    \n",
       "1961-01   14.841333  11.988333  13.431613  7.736774  11.072759   8.588065   \n",
       "1961-02   16.269286  14.975357  14.441481  9.230741  13.852143  10.937500   \n",
       "1961-03   10.890000  11.296452  10.752903  7.284000  10.509355   8.866774   \n",
       "1961-04   10.722667   9.427667   9.998000  5.830667   8.435000   6.495000   \n",
       "1961-05    9.860968   8.850000  10.818065  5.905333   9.490323   6.574839   \n",
       "1961-06    9.904138   8.520333   8.867000  6.083000  10.824000   6.707333   \n",
       "1961-07   10.614194   8.221613   9.110323  6.340968  10.532581   6.198387   \n",
       "1961-08   12.035000  10.133871  10.335806  6.845806  12.715161   8.441935   \n",
       "1961-09   12.531000   9.656897  10.776897  7.155517  11.003333   7.234000   \n",
       "1961-10   14.289667  10.915806  12.236452  8.154839  11.865484   8.333871   \n",
       "1961-11   10.896333   8.592667  11.850333  6.045667   9.123667   6.250667   \n",
       "1961-12   14.973548  11.903871  13.980323  7.073871  11.323548   8.302258   \n",
       "1962-01   14.783871  13.160323  12.591935  7.538065  11.779677   8.720000   \n",
       "1962-02   15.844643  12.041429  15.178929  9.262963  13.821429   9.726786   \n",
       "1962-03   11.634333   8.602258  12.110645  6.403226  10.352258   6.732258   \n",
       "1962-04   12.160667   9.676667  12.088333  7.163000  10.544000   7.558000   \n",
       "1962-05   12.745806  10.865484  11.874839  7.471935  11.285806   7.209032   \n",
       "1962-06   10.305667   9.677000   9.996333  6.846667  10.711333   7.441333   \n",
       "1962-07    9.981935   8.370645   9.753548  6.093226   9.112903   5.877097   \n",
       "1962-08   10.964194   9.694194  10.184516  6.701290  10.465161   7.009032   \n",
       "1962-09   11.176333   9.507000  11.640000  6.164333   9.722333   6.214000   \n",
       "1962-10    9.699355   8.063548   9.357097  4.818065   8.432258   5.730000   \n",
       "1962-11   11.071333   7.984000  12.035667  5.740000   8.135667   6.338333   \n",
       "1962-12   16.785484  13.753548  14.276452  9.557419  13.724839  10.321613   \n",
       "1963-01   14.868387  11.112903  15.121613  6.635806  11.080645   7.835484   \n",
       "1963-02   14.418929  11.876429  15.697500  8.611786  12.887857   9.600357   \n",
       "1963-03   14.853871  12.271290  14.295806  9.268387  13.112903  10.088065   \n",
       "1963-04   11.616000  10.138000  13.233667  7.990333  11.515333   9.727000   \n",
       "1963-05   12.879677  11.010645  12.881290  8.411613  12.981613   9.739677   \n",
       "1963-06   10.623333   8.434667  11.685000  6.420333  10.142667   7.219333   \n",
       "...             ...        ...        ...       ...        ...        ...   \n",
       "1976-07    9.687742   7.980968   8.267742  4.631613   7.576774   4.927419   \n",
       "1976-08    7.640645   5.366129   9.000645  3.142258   4.695484   3.847742   \n",
       "1976-09   11.703667  10.515333  10.466333  5.313333   8.761333   7.062333   \n",
       "1976-10   12.427097   9.572258  10.640000  4.885484   9.393548   6.906452   \n",
       "1976-11   10.962667   9.443667   9.202000  3.696000   7.459333   7.026333   \n",
       "1976-12   11.962258  10.086774  10.474516  3.383871   7.645484   6.148387   \n",
       "1977-01   13.404516  10.377742  12.764839  5.884516   9.159677   8.005161   \n",
       "1977-02   12.336786  11.898929  12.016786  5.317500  10.134643   9.423929   \n",
       "1977-03   16.750000  14.499677  16.118387  8.414516  13.293871  11.562258   \n",
       "1977-04   14.955333  12.293000  12.689667  7.422333  11.740000  10.137000   \n",
       "1977-05    9.441290   7.173871  12.455806  4.507742   6.198387   6.689677   \n",
       "1977-06   11.040000   8.353000  12.228000  4.864000   8.790333   7.209667   \n",
       "1977-07   10.881935   8.663548  10.816452  5.419677   9.014839   7.600000   \n",
       "1977-08    9.233548   7.727742  10.679032  4.453871   6.620645   5.961290   \n",
       "1977-09   12.472333  10.742667  11.849333  5.638667  10.077333   8.242667   \n",
       "1977-10   15.004516  13.960000  12.819677  6.754194  11.779032   9.671613   \n",
       "1977-11   16.946667  15.444667  13.561333  7.584000  12.088667   9.161333   \n",
       "1977-12   14.751935  12.744839  13.469677  6.592258  11.247742   9.466774   \n",
       "1978-01   14.291935  11.872258  12.014194  6.463226  11.402903   7.517097   \n",
       "1978-02   14.143571  12.153214  13.803214  6.828929  11.196786   7.858929   \n",
       "1978-03   14.717097  14.601935  13.334194  8.231290  12.783226   9.488710   \n",
       "1978-04   11.805000  11.255667  12.516333  5.920333  10.218000   7.301667   \n",
       "1978-05    8.270645   7.226774   6.901613  3.740645   6.973871   4.449677   \n",
       "1978-06   11.386667   9.474333  10.253333  6.053000  10.395333   7.490333   \n",
       "1978-07   12.820000   9.750968   9.910323  6.483871  10.055161   7.820645   \n",
       "1978-08    9.645161   8.259355   9.032258  4.502903   7.368065   5.935161   \n",
       "1978-09   10.913667  10.895000  10.635000  5.725000  10.372000   9.278333   \n",
       "1978-10    9.897742   8.670968   9.295806  4.721290   8.525161   6.774194   \n",
       "1978-11   16.151667  14.802667  13.508000  7.317333  11.475000   8.743000   \n",
       "1978-12   16.175484  13.748065  15.635161  7.094839  11.398710   9.241613   \n",
       "\n",
       "                DUB        CLA        MUL        CLO        BEL        MAL  \n",
       "Yr_Mo_Dy                                                                    \n",
       "1961-01   11.184839   9.245333   9.085806  10.107419  13.880968  14.703226  \n",
       "1961-02   11.890714  11.846071  11.821429  12.714286  18.583214  15.411786  \n",
       "1961-03    9.644194   9.829677  10.294138  11.251935  16.410968  15.720000  \n",
       "1961-04    6.925333   7.094667   7.342333   7.237000  11.147333  10.278333  \n",
       "1961-05    7.604000   8.177097   8.039355   8.499355  11.900323  12.011613  \n",
       "1961-06    9.095667   8.849333   9.086667   9.940333  13.995000  14.553793  \n",
       "1961-07    8.353333   8.284194   8.077097   8.891613  11.092581  12.312903  \n",
       "1961-08   10.093871  10.460968   9.111613  10.544667  14.410000  14.345333  \n",
       "1961-09    8.206000   8.936552   7.728333   9.931333  13.718333  12.921667  \n",
       "1961-10   11.194194   9.271935   8.942667  11.455806  14.229355  16.793226  \n",
       "1961-11   10.869655   6.313667   6.575000   8.383667  10.776667  12.146000  \n",
       "1961-12   11.753548   8.163226   7.965806   9.246774  12.239355  13.098710  \n",
       "1962-01   14.211935   9.600000   9.670000  11.498710  16.369355  15.661613  \n",
       "1962-02   16.916429  11.285357  12.021071  12.126429  16.705357  18.426786  \n",
       "1962-03   10.223226   7.641935   7.092258   8.052581   9.690000  11.509000  \n",
       "1962-04   11.480000   8.722000   8.703667   9.311667  12.234333  11.780667  \n",
       "1962-05   10.105806   9.084516   7.868065   9.293226  12.130000  12.922581  \n",
       "1962-06   10.548667  10.306667   9.196000  10.520333  13.757000  15.218333  \n",
       "1962-07    7.781613   8.123226   6.829677   8.613226  10.783871  11.326129  \n",
       "1962-08   11.136774   9.097419   8.645484   9.511613  13.119032  15.420968  \n",
       "1962-09    8.488000   7.020333   6.372667   8.286000  11.483667  12.313333  \n",
       "1962-10    8.448065   7.626774   6.630645   9.091290  13.286774  14.090323  \n",
       "1962-11    9.615333   5.943000   6.362333   8.084333   9.786667  13.298333  \n",
       "1962-12   13.735806  11.212258  10.683548  11.881935  16.043548  20.074516  \n",
       "1963-01   12.797419   9.844839   7.841613   9.390000  11.428710  18.822258  \n",
       "1963-02   12.729286  10.823214   8.981786  10.355714  13.266429  17.120714  \n",
       "1963-03   12.168387  11.340968   9.690968  11.515484  13.982903  14.132581  \n",
       "1963-04   11.979000  11.353000  10.341667  11.900333  13.875667  16.333667  \n",
       "1963-05   12.280968  10.964194  10.745161  11.394839  14.777097  14.975161  \n",
       "1963-06    9.267333   9.589333   8.583667   9.585333  12.098000  11.358667  \n",
       "...             ...        ...        ...        ...        ...        ...  \n",
       "1976-07    6.994839   5.135806   7.941290   6.491290  10.264194  11.912258  \n",
       "1976-08    5.437097   3.362581   5.946452   4.496452   7.079677   9.438387  \n",
       "1976-09    8.617667   6.415333   8.953333   7.263333  11.587000  17.634000  \n",
       "1976-10    6.380323   6.933226   7.552258   7.449032  11.837742  15.078065  \n",
       "1976-11    9.058333   5.791000   6.577000   7.512333  12.568333  15.685333  \n",
       "1976-12    8.034516   4.500000   5.952258   6.147742   7.814839  14.346774  \n",
       "1977-01   10.107419   7.211613   8.280000   9.328387  12.131935  18.830000  \n",
       "1977-02   10.949643   7.965357   9.320000   8.711429  11.435357  17.561429  \n",
       "1977-03   14.283226  11.361613  12.102581  11.906452  15.863226  19.133548  \n",
       "1977-04   13.887667   9.574000  10.342333  11.419667  15.593667  18.274667  \n",
       "1977-05    9.226452   5.638387   6.699355   6.045484  10.213548  11.936129  \n",
       "1977-06    8.799667   5.931000   7.065333   6.583333  11.321333  11.175333  \n",
       "1977-07    9.961935   6.526129   7.980968   7.620000  12.924194  12.186774  \n",
       "1977-08    8.943548   4.543226   6.384839   5.694839   9.825161  11.659355  \n",
       "1977-09   11.939333   7.923000   8.828000   8.506333  14.051000  17.030333  \n",
       "1977-10   12.924839  11.875161  11.481290  10.340323  17.640968  19.842903  \n",
       "1977-11   14.051000  11.286000  10.318667  10.327000  17.215333  22.333000  \n",
       "1977-12   13.231613  10.703871  10.401613   9.415484  13.237419  19.299677  \n",
       "1978-01   12.207097  10.206452   9.549032   9.247419  15.101613  20.715806  \n",
       "1978-02   11.903214  11.068929  10.052143   8.093929  10.353929  17.298571  \n",
       "1978-03   12.129355  11.665161  11.656452   9.657097  14.234194  18.611290  \n",
       "1978-04    8.586333   8.306667   8.537000   6.999000  11.190667  14.152000  \n",
       "1978-05    5.420968   6.130645   5.742581   5.926452   9.263548  10.756452  \n",
       "1978-06    7.928000   7.802000   8.220333   7.550000  11.501000  15.078667  \n",
       "1978-07    7.831935   8.459355   8.523871   7.732903  12.648710  14.077419  \n",
       "1978-08    5.650323   5.417742   7.241290   5.536774  10.466774  12.054194  \n",
       "1978-09   10.790333   9.583000  10.069333   8.939000  15.680333  19.391333  \n",
       "1978-10    8.115484   7.337742   8.297742   8.243871  13.776774  17.150000  \n",
       "1978-11   11.492333   9.657333  10.701333  10.676000  17.404667  20.723000  \n",
       "1978-12   12.077419  10.194839  10.616774  11.028710  13.859677  21.371613  \n",
       "\n",
       "[216 rows x 12 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(data.index.to_period('M')).mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 14. Downsample the record to a weekly frequency for each location."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1960-12-26/1961-01-01</th>\n",
       "      <td>15.040000</td>\n",
       "      <td>14.960000</td>\n",
       "      <td>13.170000</td>\n",
       "      <td>9.290000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.870000</td>\n",
       "      <td>13.670000</td>\n",
       "      <td>10.250000</td>\n",
       "      <td>10.830000</td>\n",
       "      <td>12.580000</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>15.040000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02/1961-01-08</th>\n",
       "      <td>13.541429</td>\n",
       "      <td>11.486667</td>\n",
       "      <td>10.487143</td>\n",
       "      <td>6.417143</td>\n",
       "      <td>9.474286</td>\n",
       "      <td>6.435714</td>\n",
       "      <td>11.061429</td>\n",
       "      <td>6.616667</td>\n",
       "      <td>8.434286</td>\n",
       "      <td>8.497143</td>\n",
       "      <td>12.481429</td>\n",
       "      <td>13.238571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-09/1961-01-15</th>\n",
       "      <td>12.468571</td>\n",
       "      <td>8.967143</td>\n",
       "      <td>11.958571</td>\n",
       "      <td>4.630000</td>\n",
       "      <td>7.351429</td>\n",
       "      <td>5.072857</td>\n",
       "      <td>7.535714</td>\n",
       "      <td>6.820000</td>\n",
       "      <td>5.712857</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>11.125714</td>\n",
       "      <td>11.024286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-16/1961-01-22</th>\n",
       "      <td>13.204286</td>\n",
       "      <td>9.862857</td>\n",
       "      <td>12.982857</td>\n",
       "      <td>6.328571</td>\n",
       "      <td>8.966667</td>\n",
       "      <td>7.417143</td>\n",
       "      <td>9.257143</td>\n",
       "      <td>7.875714</td>\n",
       "      <td>7.145714</td>\n",
       "      <td>8.124286</td>\n",
       "      <td>9.821429</td>\n",
       "      <td>11.434286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-23/1961-01-29</th>\n",
       "      <td>19.880000</td>\n",
       "      <td>16.141429</td>\n",
       "      <td>18.225714</td>\n",
       "      <td>12.720000</td>\n",
       "      <td>17.432857</td>\n",
       "      <td>14.828571</td>\n",
       "      <td>15.528571</td>\n",
       "      <td>15.160000</td>\n",
       "      <td>14.480000</td>\n",
       "      <td>15.640000</td>\n",
       "      <td>20.930000</td>\n",
       "      <td>22.530000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-30/1961-02-05</th>\n",
       "      <td>16.827143</td>\n",
       "      <td>15.460000</td>\n",
       "      <td>12.618571</td>\n",
       "      <td>8.247143</td>\n",
       "      <td>13.361429</td>\n",
       "      <td>9.107143</td>\n",
       "      <td>12.204286</td>\n",
       "      <td>8.548571</td>\n",
       "      <td>9.821429</td>\n",
       "      <td>9.460000</td>\n",
       "      <td>14.012857</td>\n",
       "      <td>11.935714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-06/1961-02-12</th>\n",
       "      <td>19.684286</td>\n",
       "      <td>16.417143</td>\n",
       "      <td>17.304286</td>\n",
       "      <td>10.774286</td>\n",
       "      <td>14.718571</td>\n",
       "      <td>12.522857</td>\n",
       "      <td>14.934286</td>\n",
       "      <td>14.850000</td>\n",
       "      <td>14.064286</td>\n",
       "      <td>14.440000</td>\n",
       "      <td>21.832857</td>\n",
       "      <td>19.155714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-13/1961-02-19</th>\n",
       "      <td>15.130000</td>\n",
       "      <td>15.091429</td>\n",
       "      <td>13.797143</td>\n",
       "      <td>10.083333</td>\n",
       "      <td>13.410000</td>\n",
       "      <td>11.868571</td>\n",
       "      <td>9.542857</td>\n",
       "      <td>12.128571</td>\n",
       "      <td>12.375714</td>\n",
       "      <td>13.542857</td>\n",
       "      <td>21.167143</td>\n",
       "      <td>16.584286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-20/1961-02-26</th>\n",
       "      <td>15.221429</td>\n",
       "      <td>13.625714</td>\n",
       "      <td>14.334286</td>\n",
       "      <td>8.524286</td>\n",
       "      <td>13.655714</td>\n",
       "      <td>10.114286</td>\n",
       "      <td>11.150000</td>\n",
       "      <td>10.875714</td>\n",
       "      <td>10.392857</td>\n",
       "      <td>12.730000</td>\n",
       "      <td>16.304286</td>\n",
       "      <td>14.322857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-27/1961-03-05</th>\n",
       "      <td>12.101429</td>\n",
       "      <td>12.951429</td>\n",
       "      <td>11.063333</td>\n",
       "      <td>7.834286</td>\n",
       "      <td>12.101429</td>\n",
       "      <td>9.238571</td>\n",
       "      <td>10.232857</td>\n",
       "      <td>11.130000</td>\n",
       "      <td>10.383333</td>\n",
       "      <td>12.370000</td>\n",
       "      <td>17.842857</td>\n",
       "      <td>13.951667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-06/1961-03-12</th>\n",
       "      <td>9.376667</td>\n",
       "      <td>11.578571</td>\n",
       "      <td>10.845714</td>\n",
       "      <td>7.137143</td>\n",
       "      <td>10.940000</td>\n",
       "      <td>9.488571</td>\n",
       "      <td>6.881429</td>\n",
       "      <td>9.637143</td>\n",
       "      <td>9.885714</td>\n",
       "      <td>10.458571</td>\n",
       "      <td>16.701429</td>\n",
       "      <td>14.420000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-13/1961-03-19</th>\n",
       "      <td>11.911429</td>\n",
       "      <td>13.501429</td>\n",
       "      <td>11.607143</td>\n",
       "      <td>7.084286</td>\n",
       "      <td>10.751429</td>\n",
       "      <td>8.652857</td>\n",
       "      <td>10.041429</td>\n",
       "      <td>10.220000</td>\n",
       "      <td>10.101429</td>\n",
       "      <td>11.627143</td>\n",
       "      <td>19.350000</td>\n",
       "      <td>16.227143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-20/1961-03-26</th>\n",
       "      <td>9.567143</td>\n",
       "      <td>8.387143</td>\n",
       "      <td>9.695714</td>\n",
       "      <td>6.648571</td>\n",
       "      <td>8.964286</td>\n",
       "      <td>7.982857</td>\n",
       "      <td>10.774286</td>\n",
       "      <td>8.977143</td>\n",
       "      <td>10.904286</td>\n",
       "      <td>11.481429</td>\n",
       "      <td>14.037143</td>\n",
       "      <td>18.134286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-27/1961-04-02</th>\n",
       "      <td>10.757143</td>\n",
       "      <td>8.852857</td>\n",
       "      <td>9.501429</td>\n",
       "      <td>7.300000</td>\n",
       "      <td>9.975714</td>\n",
       "      <td>9.165714</td>\n",
       "      <td>11.125714</td>\n",
       "      <td>9.061429</td>\n",
       "      <td>10.478333</td>\n",
       "      <td>9.631429</td>\n",
       "      <td>13.471429</td>\n",
       "      <td>13.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04-03/1961-04-09</th>\n",
       "      <td>11.964286</td>\n",
       "      <td>10.654286</td>\n",
       "      <td>13.607143</td>\n",
       "      <td>5.958571</td>\n",
       "      <td>9.494286</td>\n",
       "      <td>7.637143</td>\n",
       "      <td>7.107143</td>\n",
       "      <td>8.041429</td>\n",
       "      <td>8.161429</td>\n",
       "      <td>7.238571</td>\n",
       "      <td>11.712857</td>\n",
       "      <td>11.371429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04-10/1961-04-16</th>\n",
       "      <td>8.965714</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>8.787143</td>\n",
       "      <td>4.971429</td>\n",
       "      <td>6.405714</td>\n",
       "      <td>4.947143</td>\n",
       "      <td>5.005714</td>\n",
       "      <td>4.994286</td>\n",
       "      <td>5.718571</td>\n",
       "      <td>6.178571</td>\n",
       "      <td>9.482857</td>\n",
       "      <td>8.690000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04-17/1961-04-23</th>\n",
       "      <td>12.621429</td>\n",
       "      <td>10.438571</td>\n",
       "      <td>10.255714</td>\n",
       "      <td>7.768571</td>\n",
       "      <td>10.357143</td>\n",
       "      <td>7.798571</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>9.111429</td>\n",
       "      <td>8.767143</td>\n",
       "      <td>9.551429</td>\n",
       "      <td>13.620000</td>\n",
       "      <td>12.470000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04-24/1961-04-30</th>\n",
       "      <td>10.117143</td>\n",
       "      <td>9.798571</td>\n",
       "      <td>8.281429</td>\n",
       "      <td>4.801429</td>\n",
       "      <td>7.892857</td>\n",
       "      <td>5.197143</td>\n",
       "      <td>6.150000</td>\n",
       "      <td>6.377143</td>\n",
       "      <td>6.242857</td>\n",
       "      <td>6.124286</td>\n",
       "      <td>9.720000</td>\n",
       "      <td>8.637143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-01/1961-05-07</th>\n",
       "      <td>15.367143</td>\n",
       "      <td>13.970000</td>\n",
       "      <td>13.834286</td>\n",
       "      <td>9.952857</td>\n",
       "      <td>14.917143</td>\n",
       "      <td>10.864286</td>\n",
       "      <td>11.435714</td>\n",
       "      <td>12.244286</td>\n",
       "      <td>11.677143</td>\n",
       "      <td>11.585714</td>\n",
       "      <td>17.548571</td>\n",
       "      <td>14.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-08/1961-05-14</th>\n",
       "      <td>7.772857</td>\n",
       "      <td>8.712857</td>\n",
       "      <td>8.172857</td>\n",
       "      <td>5.295714</td>\n",
       "      <td>9.150000</td>\n",
       "      <td>6.391429</td>\n",
       "      <td>8.013333</td>\n",
       "      <td>7.052857</td>\n",
       "      <td>7.528571</td>\n",
       "      <td>7.822857</td>\n",
       "      <td>10.421429</td>\n",
       "      <td>10.382857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-15/1961-05-21</th>\n",
       "      <td>8.225714</td>\n",
       "      <td>5.631667</td>\n",
       "      <td>12.042857</td>\n",
       "      <td>4.258571</td>\n",
       "      <td>7.597143</td>\n",
       "      <td>5.022857</td>\n",
       "      <td>5.695714</td>\n",
       "      <td>6.970000</td>\n",
       "      <td>6.847143</td>\n",
       "      <td>7.114286</td>\n",
       "      <td>9.624286</td>\n",
       "      <td>10.612857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-22/1961-05-28</th>\n",
       "      <td>8.155714</td>\n",
       "      <td>7.388571</td>\n",
       "      <td>8.512857</td>\n",
       "      <td>3.748333</td>\n",
       "      <td>6.941429</td>\n",
       "      <td>4.112857</td>\n",
       "      <td>5.142857</td>\n",
       "      <td>6.272857</td>\n",
       "      <td>6.108571</td>\n",
       "      <td>7.535714</td>\n",
       "      <td>10.518571</td>\n",
       "      <td>11.697143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-29/1961-06-04</th>\n",
       "      <td>10.321429</td>\n",
       "      <td>7.407143</td>\n",
       "      <td>10.065714</td>\n",
       "      <td>6.310000</td>\n",
       "      <td>9.754286</td>\n",
       "      <td>6.451429</td>\n",
       "      <td>8.344286</td>\n",
       "      <td>8.635714</td>\n",
       "      <td>8.714286</td>\n",
       "      <td>9.035714</td>\n",
       "      <td>12.298571</td>\n",
       "      <td>13.597143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06-05/1961-06-11</th>\n",
       "      <td>10.917143</td>\n",
       "      <td>8.992857</td>\n",
       "      <td>8.095714</td>\n",
       "      <td>5.214286</td>\n",
       "      <td>10.030000</td>\n",
       "      <td>5.460000</td>\n",
       "      <td>7.084286</td>\n",
       "      <td>6.884286</td>\n",
       "      <td>8.034286</td>\n",
       "      <td>8.397143</td>\n",
       "      <td>10.148571</td>\n",
       "      <td>12.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06-12/1961-06-18</th>\n",
       "      <td>10.571429</td>\n",
       "      <td>9.565714</td>\n",
       "      <td>10.875714</td>\n",
       "      <td>6.520000</td>\n",
       "      <td>10.260000</td>\n",
       "      <td>6.947143</td>\n",
       "      <td>9.278571</td>\n",
       "      <td>9.102857</td>\n",
       "      <td>8.992857</td>\n",
       "      <td>9.594286</td>\n",
       "      <td>15.351429</td>\n",
       "      <td>15.025714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06-19/1961-06-25</th>\n",
       "      <td>7.345714</td>\n",
       "      <td>6.108571</td>\n",
       "      <td>8.084286</td>\n",
       "      <td>5.478571</td>\n",
       "      <td>11.477143</td>\n",
       "      <td>7.492857</td>\n",
       "      <td>11.868571</td>\n",
       "      <td>9.447143</td>\n",
       "      <td>10.458571</td>\n",
       "      <td>11.257143</td>\n",
       "      <td>14.370000</td>\n",
       "      <td>17.410000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06-26/1961-07-02</th>\n",
       "      <td>10.236667</td>\n",
       "      <td>9.482857</td>\n",
       "      <td>8.648571</td>\n",
       "      <td>6.772857</td>\n",
       "      <td>10.975714</td>\n",
       "      <td>6.507143</td>\n",
       "      <td>7.642857</td>\n",
       "      <td>9.237143</td>\n",
       "      <td>7.904286</td>\n",
       "      <td>10.268571</td>\n",
       "      <td>14.535714</td>\n",
       "      <td>12.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-07-03/1961-07-09</th>\n",
       "      <td>11.715714</td>\n",
       "      <td>7.220000</td>\n",
       "      <td>9.320000</td>\n",
       "      <td>7.544286</td>\n",
       "      <td>12.494286</td>\n",
       "      <td>7.982857</td>\n",
       "      <td>11.888333</td>\n",
       "      <td>9.308571</td>\n",
       "      <td>10.732857</td>\n",
       "      <td>10.547143</td>\n",
       "      <td>12.220000</td>\n",
       "      <td>15.987143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-07-10/1961-07-16</th>\n",
       "      <td>16.680000</td>\n",
       "      <td>13.518571</td>\n",
       "      <td>11.171429</td>\n",
       "      <td>9.277143</td>\n",
       "      <td>14.524286</td>\n",
       "      <td>8.412857</td>\n",
       "      <td>10.171429</td>\n",
       "      <td>10.507143</td>\n",
       "      <td>9.530000</td>\n",
       "      <td>10.157143</td>\n",
       "      <td>13.520000</td>\n",
       "      <td>12.524286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-07-17/1961-07-23</th>\n",
       "      <td>4.202857</td>\n",
       "      <td>4.255714</td>\n",
       "      <td>6.738571</td>\n",
       "      <td>3.300000</td>\n",
       "      <td>6.112857</td>\n",
       "      <td>2.715714</td>\n",
       "      <td>3.964286</td>\n",
       "      <td>5.642857</td>\n",
       "      <td>5.297143</td>\n",
       "      <td>6.041429</td>\n",
       "      <td>7.524286</td>\n",
       "      <td>8.415714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06-05/1978-06-11</th>\n",
       "      <td>12.022857</td>\n",
       "      <td>9.154286</td>\n",
       "      <td>9.488571</td>\n",
       "      <td>5.971429</td>\n",
       "      <td>10.637143</td>\n",
       "      <td>8.030000</td>\n",
       "      <td>8.678571</td>\n",
       "      <td>8.227143</td>\n",
       "      <td>9.172857</td>\n",
       "      <td>9.642857</td>\n",
       "      <td>11.632857</td>\n",
       "      <td>17.778571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06-12/1978-06-18</th>\n",
       "      <td>9.410000</td>\n",
       "      <td>8.770000</td>\n",
       "      <td>14.135714</td>\n",
       "      <td>6.457143</td>\n",
       "      <td>8.564286</td>\n",
       "      <td>6.898571</td>\n",
       "      <td>7.297143</td>\n",
       "      <td>7.464286</td>\n",
       "      <td>7.054286</td>\n",
       "      <td>6.225714</td>\n",
       "      <td>11.398571</td>\n",
       "      <td>12.957143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06-19/1978-06-25</th>\n",
       "      <td>12.707143</td>\n",
       "      <td>10.244286</td>\n",
       "      <td>8.912857</td>\n",
       "      <td>5.878571</td>\n",
       "      <td>10.372857</td>\n",
       "      <td>6.852857</td>\n",
       "      <td>7.648571</td>\n",
       "      <td>7.875714</td>\n",
       "      <td>7.865714</td>\n",
       "      <td>7.084286</td>\n",
       "      <td>13.030000</td>\n",
       "      <td>16.678571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06-26/1978-07-02</th>\n",
       "      <td>12.208571</td>\n",
       "      <td>9.640000</td>\n",
       "      <td>10.482857</td>\n",
       "      <td>7.011429</td>\n",
       "      <td>12.772857</td>\n",
       "      <td>9.005714</td>\n",
       "      <td>11.055714</td>\n",
       "      <td>8.917143</td>\n",
       "      <td>9.994286</td>\n",
       "      <td>7.498571</td>\n",
       "      <td>12.268571</td>\n",
       "      <td>15.287143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-03/1978-07-09</th>\n",
       "      <td>18.052857</td>\n",
       "      <td>12.630000</td>\n",
       "      <td>11.984286</td>\n",
       "      <td>9.220000</td>\n",
       "      <td>13.414286</td>\n",
       "      <td>10.762857</td>\n",
       "      <td>11.368571</td>\n",
       "      <td>11.218571</td>\n",
       "      <td>11.272857</td>\n",
       "      <td>11.082857</td>\n",
       "      <td>14.754286</td>\n",
       "      <td>18.215714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-10/1978-07-16</th>\n",
       "      <td>5.882857</td>\n",
       "      <td>3.244286</td>\n",
       "      <td>5.358571</td>\n",
       "      <td>2.250000</td>\n",
       "      <td>4.618571</td>\n",
       "      <td>2.631429</td>\n",
       "      <td>2.494286</td>\n",
       "      <td>3.540000</td>\n",
       "      <td>3.397143</td>\n",
       "      <td>3.214286</td>\n",
       "      <td>7.198571</td>\n",
       "      <td>7.578571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-17/1978-07-23</th>\n",
       "      <td>13.654286</td>\n",
       "      <td>10.007143</td>\n",
       "      <td>9.915714</td>\n",
       "      <td>6.577143</td>\n",
       "      <td>10.757143</td>\n",
       "      <td>8.282857</td>\n",
       "      <td>8.147143</td>\n",
       "      <td>9.301429</td>\n",
       "      <td>8.952857</td>\n",
       "      <td>8.402857</td>\n",
       "      <td>13.847143</td>\n",
       "      <td>14.785714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-24/1978-07-30</th>\n",
       "      <td>12.172857</td>\n",
       "      <td>11.854286</td>\n",
       "      <td>11.094286</td>\n",
       "      <td>6.631429</td>\n",
       "      <td>9.918571</td>\n",
       "      <td>8.707143</td>\n",
       "      <td>7.458571</td>\n",
       "      <td>9.117143</td>\n",
       "      <td>9.304286</td>\n",
       "      <td>8.148571</td>\n",
       "      <td>15.192857</td>\n",
       "      <td>14.584286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-31/1978-08-06</th>\n",
       "      <td>12.475714</td>\n",
       "      <td>9.488571</td>\n",
       "      <td>10.584286</td>\n",
       "      <td>5.457143</td>\n",
       "      <td>8.724286</td>\n",
       "      <td>5.855714</td>\n",
       "      <td>7.065714</td>\n",
       "      <td>5.410000</td>\n",
       "      <td>6.631429</td>\n",
       "      <td>4.962857</td>\n",
       "      <td>9.084286</td>\n",
       "      <td>11.405714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08-07/1978-08-13</th>\n",
       "      <td>10.114286</td>\n",
       "      <td>9.600000</td>\n",
       "      <td>7.635714</td>\n",
       "      <td>4.790000</td>\n",
       "      <td>8.101429</td>\n",
       "      <td>6.702857</td>\n",
       "      <td>5.452857</td>\n",
       "      <td>5.964286</td>\n",
       "      <td>7.518571</td>\n",
       "      <td>5.661429</td>\n",
       "      <td>10.691429</td>\n",
       "      <td>11.927143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08-14/1978-08-20</th>\n",
       "      <td>11.100000</td>\n",
       "      <td>11.237143</td>\n",
       "      <td>10.505714</td>\n",
       "      <td>5.697143</td>\n",
       "      <td>9.910000</td>\n",
       "      <td>8.034286</td>\n",
       "      <td>7.267143</td>\n",
       "      <td>8.517143</td>\n",
       "      <td>9.815714</td>\n",
       "      <td>7.941429</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>14.405714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08-21/1978-08-27</th>\n",
       "      <td>6.208571</td>\n",
       "      <td>5.060000</td>\n",
       "      <td>8.565714</td>\n",
       "      <td>3.121429</td>\n",
       "      <td>4.638571</td>\n",
       "      <td>4.077143</td>\n",
       "      <td>3.291429</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>5.877143</td>\n",
       "      <td>4.447143</td>\n",
       "      <td>8.131429</td>\n",
       "      <td>10.661429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08-28/1978-09-03</th>\n",
       "      <td>8.232857</td>\n",
       "      <td>4.888571</td>\n",
       "      <td>7.767143</td>\n",
       "      <td>3.588571</td>\n",
       "      <td>3.892857</td>\n",
       "      <td>5.090000</td>\n",
       "      <td>6.184286</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>6.202857</td>\n",
       "      <td>4.745714</td>\n",
       "      <td>8.105714</td>\n",
       "      <td>13.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09-04/1978-09-10</th>\n",
       "      <td>11.487143</td>\n",
       "      <td>12.742857</td>\n",
       "      <td>11.124286</td>\n",
       "      <td>5.702857</td>\n",
       "      <td>10.721429</td>\n",
       "      <td>10.927143</td>\n",
       "      <td>9.157143</td>\n",
       "      <td>9.458571</td>\n",
       "      <td>10.588571</td>\n",
       "      <td>8.274286</td>\n",
       "      <td>14.560000</td>\n",
       "      <td>16.752857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09-11/1978-09-17</th>\n",
       "      <td>12.067143</td>\n",
       "      <td>10.648571</td>\n",
       "      <td>11.610000</td>\n",
       "      <td>6.864286</td>\n",
       "      <td>12.252857</td>\n",
       "      <td>11.868571</td>\n",
       "      <td>13.017143</td>\n",
       "      <td>12.447143</td>\n",
       "      <td>11.908571</td>\n",
       "      <td>10.957143</td>\n",
       "      <td>18.422857</td>\n",
       "      <td>23.441429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09-18/1978-09-24</th>\n",
       "      <td>5.845714</td>\n",
       "      <td>8.317143</td>\n",
       "      <td>9.305714</td>\n",
       "      <td>2.554286</td>\n",
       "      <td>5.625714</td>\n",
       "      <td>5.171429</td>\n",
       "      <td>7.047143</td>\n",
       "      <td>6.750000</td>\n",
       "      <td>6.870000</td>\n",
       "      <td>6.291429</td>\n",
       "      <td>13.447143</td>\n",
       "      <td>15.324286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09-25/1978-10-01</th>\n",
       "      <td>16.252857</td>\n",
       "      <td>14.131429</td>\n",
       "      <td>12.098571</td>\n",
       "      <td>8.832857</td>\n",
       "      <td>15.810000</td>\n",
       "      <td>10.338571</td>\n",
       "      <td>15.124286</td>\n",
       "      <td>12.378571</td>\n",
       "      <td>12.275714</td>\n",
       "      <td>11.970000</td>\n",
       "      <td>19.160000</td>\n",
       "      <td>24.158571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-02/1978-10-08</th>\n",
       "      <td>12.865714</td>\n",
       "      <td>13.302857</td>\n",
       "      <td>11.671429</td>\n",
       "      <td>6.531429</td>\n",
       "      <td>11.731429</td>\n",
       "      <td>8.881429</td>\n",
       "      <td>9.707143</td>\n",
       "      <td>9.708571</td>\n",
       "      <td>11.391429</td>\n",
       "      <td>10.161429</td>\n",
       "      <td>16.498571</td>\n",
       "      <td>20.618571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-09/1978-10-15</th>\n",
       "      <td>9.611429</td>\n",
       "      <td>6.327143</td>\n",
       "      <td>9.250000</td>\n",
       "      <td>4.167143</td>\n",
       "      <td>6.821429</td>\n",
       "      <td>6.237143</td>\n",
       "      <td>5.577143</td>\n",
       "      <td>6.348571</td>\n",
       "      <td>7.232857</td>\n",
       "      <td>7.285714</td>\n",
       "      <td>12.197143</td>\n",
       "      <td>14.177143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-16/1978-10-22</th>\n",
       "      <td>9.804286</td>\n",
       "      <td>7.817143</td>\n",
       "      <td>7.642857</td>\n",
       "      <td>5.314286</td>\n",
       "      <td>9.124286</td>\n",
       "      <td>6.862857</td>\n",
       "      <td>9.391429</td>\n",
       "      <td>7.428571</td>\n",
       "      <td>7.765714</td>\n",
       "      <td>8.048571</td>\n",
       "      <td>12.708571</td>\n",
       "      <td>17.868571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-23/1978-10-29</th>\n",
       "      <td>7.504286</td>\n",
       "      <td>7.702857</td>\n",
       "      <td>8.102857</td>\n",
       "      <td>3.204286</td>\n",
       "      <td>7.464286</td>\n",
       "      <td>5.905714</td>\n",
       "      <td>8.727143</td>\n",
       "      <td>6.652857</td>\n",
       "      <td>7.605714</td>\n",
       "      <td>8.120000</td>\n",
       "      <td>14.487143</td>\n",
       "      <td>16.915714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-30/1978-11-05</th>\n",
       "      <td>13.060000</td>\n",
       "      <td>13.465714</td>\n",
       "      <td>12.137143</td>\n",
       "      <td>6.682857</td>\n",
       "      <td>9.891429</td>\n",
       "      <td>8.314286</td>\n",
       "      <td>9.775714</td>\n",
       "      <td>9.638571</td>\n",
       "      <td>10.185714</td>\n",
       "      <td>10.422857</td>\n",
       "      <td>18.451429</td>\n",
       "      <td>18.721429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11-06/1978-11-12</th>\n",
       "      <td>14.857143</td>\n",
       "      <td>15.237143</td>\n",
       "      <td>12.007143</td>\n",
       "      <td>7.684286</td>\n",
       "      <td>12.460000</td>\n",
       "      <td>9.352857</td>\n",
       "      <td>10.224286</td>\n",
       "      <td>10.554286</td>\n",
       "      <td>11.168571</td>\n",
       "      <td>12.232857</td>\n",
       "      <td>19.307143</td>\n",
       "      <td>22.522857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11-13/1978-11-19</th>\n",
       "      <td>20.590000</td>\n",
       "      <td>18.998571</td>\n",
       "      <td>17.272857</td>\n",
       "      <td>10.417143</td>\n",
       "      <td>14.220000</td>\n",
       "      <td>11.208571</td>\n",
       "      <td>16.081429</td>\n",
       "      <td>12.915714</td>\n",
       "      <td>13.297143</td>\n",
       "      <td>13.242857</td>\n",
       "      <td>20.357143</td>\n",
       "      <td>23.905714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11-20/1978-11-26</th>\n",
       "      <td>16.498571</td>\n",
       "      <td>13.971429</td>\n",
       "      <td>13.544286</td>\n",
       "      <td>6.361429</td>\n",
       "      <td>10.438571</td>\n",
       "      <td>7.404286</td>\n",
       "      <td>12.797143</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>9.998571</td>\n",
       "      <td>8.915714</td>\n",
       "      <td>15.207143</td>\n",
       "      <td>19.491429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11-27/1978-12-03</th>\n",
       "      <td>14.934286</td>\n",
       "      <td>11.232857</td>\n",
       "      <td>13.941429</td>\n",
       "      <td>5.565714</td>\n",
       "      <td>10.215714</td>\n",
       "      <td>8.618571</td>\n",
       "      <td>9.642857</td>\n",
       "      <td>7.685714</td>\n",
       "      <td>9.011429</td>\n",
       "      <td>9.547143</td>\n",
       "      <td>11.835714</td>\n",
       "      <td>18.728571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12-04/1978-12-10</th>\n",
       "      <td>20.740000</td>\n",
       "      <td>19.190000</td>\n",
       "      <td>17.034286</td>\n",
       "      <td>9.777143</td>\n",
       "      <td>15.287143</td>\n",
       "      <td>12.774286</td>\n",
       "      <td>14.437143</td>\n",
       "      <td>12.488571</td>\n",
       "      <td>13.870000</td>\n",
       "      <td>14.082857</td>\n",
       "      <td>18.517143</td>\n",
       "      <td>23.061429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12-11/1978-12-17</th>\n",
       "      <td>16.758571</td>\n",
       "      <td>14.692857</td>\n",
       "      <td>14.987143</td>\n",
       "      <td>6.917143</td>\n",
       "      <td>11.397143</td>\n",
       "      <td>7.272857</td>\n",
       "      <td>10.208571</td>\n",
       "      <td>7.967143</td>\n",
       "      <td>9.168571</td>\n",
       "      <td>8.565714</td>\n",
       "      <td>11.102857</td>\n",
       "      <td>15.562857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12-18/1978-12-24</th>\n",
       "      <td>11.155714</td>\n",
       "      <td>8.008571</td>\n",
       "      <td>13.172857</td>\n",
       "      <td>4.004286</td>\n",
       "      <td>7.825714</td>\n",
       "      <td>6.290000</td>\n",
       "      <td>7.798571</td>\n",
       "      <td>8.667143</td>\n",
       "      <td>7.151429</td>\n",
       "      <td>8.072857</td>\n",
       "      <td>11.845714</td>\n",
       "      <td>18.977143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12-25/1978-12-31</th>\n",
       "      <td>14.951429</td>\n",
       "      <td>11.801429</td>\n",
       "      <td>16.035714</td>\n",
       "      <td>6.507143</td>\n",
       "      <td>9.660000</td>\n",
       "      <td>8.620000</td>\n",
       "      <td>13.708571</td>\n",
       "      <td>10.477143</td>\n",
       "      <td>10.868571</td>\n",
       "      <td>11.471429</td>\n",
       "      <td>12.947143</td>\n",
       "      <td>26.844286</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>940 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             RPT        VAL        ROS        KIL        SHA  \\\n",
       "Yr_Mo_Dy                                                                       \n",
       "1960-12-26/1961-01-01  15.040000  14.960000  13.170000   9.290000        NaN   \n",
       "1961-01-02/1961-01-08  13.541429  11.486667  10.487143   6.417143   9.474286   \n",
       "1961-01-09/1961-01-15  12.468571   8.967143  11.958571   4.630000   7.351429   \n",
       "1961-01-16/1961-01-22  13.204286   9.862857  12.982857   6.328571   8.966667   \n",
       "1961-01-23/1961-01-29  19.880000  16.141429  18.225714  12.720000  17.432857   \n",
       "1961-01-30/1961-02-05  16.827143  15.460000  12.618571   8.247143  13.361429   \n",
       "1961-02-06/1961-02-12  19.684286  16.417143  17.304286  10.774286  14.718571   \n",
       "1961-02-13/1961-02-19  15.130000  15.091429  13.797143  10.083333  13.410000   \n",
       "1961-02-20/1961-02-26  15.221429  13.625714  14.334286   8.524286  13.655714   \n",
       "1961-02-27/1961-03-05  12.101429  12.951429  11.063333   7.834286  12.101429   \n",
       "1961-03-06/1961-03-12   9.376667  11.578571  10.845714   7.137143  10.940000   \n",
       "1961-03-13/1961-03-19  11.911429  13.501429  11.607143   7.084286  10.751429   \n",
       "1961-03-20/1961-03-26   9.567143   8.387143   9.695714   6.648571   8.964286   \n",
       "1961-03-27/1961-04-02  10.757143   8.852857   9.501429   7.300000   9.975714   \n",
       "1961-04-03/1961-04-09  11.964286  10.654286  13.607143   5.958571   9.494286   \n",
       "1961-04-10/1961-04-16   8.965714   8.000000   8.787143   4.971429   6.405714   \n",
       "1961-04-17/1961-04-23  12.621429  10.438571  10.255714   7.768571  10.357143   \n",
       "1961-04-24/1961-04-30  10.117143   9.798571   8.281429   4.801429   7.892857   \n",
       "1961-05-01/1961-05-07  15.367143  13.970000  13.834286   9.952857  14.917143   \n",
       "1961-05-08/1961-05-14   7.772857   8.712857   8.172857   5.295714   9.150000   \n",
       "1961-05-15/1961-05-21   8.225714   5.631667  12.042857   4.258571   7.597143   \n",
       "1961-05-22/1961-05-28   8.155714   7.388571   8.512857   3.748333   6.941429   \n",
       "1961-05-29/1961-06-04  10.321429   7.407143  10.065714   6.310000   9.754286   \n",
       "1961-06-05/1961-06-11  10.917143   8.992857   8.095714   5.214286  10.030000   \n",
       "1961-06-12/1961-06-18  10.571429   9.565714  10.875714   6.520000  10.260000   \n",
       "1961-06-19/1961-06-25   7.345714   6.108571   8.084286   5.478571  11.477143   \n",
       "1961-06-26/1961-07-02  10.236667   9.482857   8.648571   6.772857  10.975714   \n",
       "1961-07-03/1961-07-09  11.715714   7.220000   9.320000   7.544286  12.494286   \n",
       "1961-07-10/1961-07-16  16.680000  13.518571  11.171429   9.277143  14.524286   \n",
       "1961-07-17/1961-07-23   4.202857   4.255714   6.738571   3.300000   6.112857   \n",
       "...                          ...        ...        ...        ...        ...   \n",
       "1978-06-05/1978-06-11  12.022857   9.154286   9.488571   5.971429  10.637143   \n",
       "1978-06-12/1978-06-18   9.410000   8.770000  14.135714   6.457143   8.564286   \n",
       "1978-06-19/1978-06-25  12.707143  10.244286   8.912857   5.878571  10.372857   \n",
       "1978-06-26/1978-07-02  12.208571   9.640000  10.482857   7.011429  12.772857   \n",
       "1978-07-03/1978-07-09  18.052857  12.630000  11.984286   9.220000  13.414286   \n",
       "1978-07-10/1978-07-16   5.882857   3.244286   5.358571   2.250000   4.618571   \n",
       "1978-07-17/1978-07-23  13.654286  10.007143   9.915714   6.577143  10.757143   \n",
       "1978-07-24/1978-07-30  12.172857  11.854286  11.094286   6.631429   9.918571   \n",
       "1978-07-31/1978-08-06  12.475714   9.488571  10.584286   5.457143   8.724286   \n",
       "1978-08-07/1978-08-13  10.114286   9.600000   7.635714   4.790000   8.101429   \n",
       "1978-08-14/1978-08-20  11.100000  11.237143  10.505714   5.697143   9.910000   \n",
       "1978-08-21/1978-08-27   6.208571   5.060000   8.565714   3.121429   4.638571   \n",
       "1978-08-28/1978-09-03   8.232857   4.888571   7.767143   3.588571   3.892857   \n",
       "1978-09-04/1978-09-10  11.487143  12.742857  11.124286   5.702857  10.721429   \n",
       "1978-09-11/1978-09-17  12.067143  10.648571  11.610000   6.864286  12.252857   \n",
       "1978-09-18/1978-09-24   5.845714   8.317143   9.305714   2.554286   5.625714   \n",
       "1978-09-25/1978-10-01  16.252857  14.131429  12.098571   8.832857  15.810000   \n",
       "1978-10-02/1978-10-08  12.865714  13.302857  11.671429   6.531429  11.731429   \n",
       "1978-10-09/1978-10-15   9.611429   6.327143   9.250000   4.167143   6.821429   \n",
       "1978-10-16/1978-10-22   9.804286   7.817143   7.642857   5.314286   9.124286   \n",
       "1978-10-23/1978-10-29   7.504286   7.702857   8.102857   3.204286   7.464286   \n",
       "1978-10-30/1978-11-05  13.060000  13.465714  12.137143   6.682857   9.891429   \n",
       "1978-11-06/1978-11-12  14.857143  15.237143  12.007143   7.684286  12.460000   \n",
       "1978-11-13/1978-11-19  20.590000  18.998571  17.272857  10.417143  14.220000   \n",
       "1978-11-20/1978-11-26  16.498571  13.971429  13.544286   6.361429  10.438571   \n",
       "1978-11-27/1978-12-03  14.934286  11.232857  13.941429   5.565714  10.215714   \n",
       "1978-12-04/1978-12-10  20.740000  19.190000  17.034286   9.777143  15.287143   \n",
       "1978-12-11/1978-12-17  16.758571  14.692857  14.987143   6.917143  11.397143   \n",
       "1978-12-18/1978-12-24  11.155714   8.008571  13.172857   4.004286   7.825714   \n",
       "1978-12-25/1978-12-31  14.951429  11.801429  16.035714   6.507143   9.660000   \n",
       "\n",
       "                             BIR        DUB        CLA        MUL        CLO  \\\n",
       "Yr_Mo_Dy                                                                       \n",
       "1960-12-26/1961-01-01   9.870000  13.670000  10.250000  10.830000  12.580000   \n",
       "1961-01-02/1961-01-08   6.435714  11.061429   6.616667   8.434286   8.497143   \n",
       "1961-01-09/1961-01-15   5.072857   7.535714   6.820000   5.712857   7.571429   \n",
       "1961-01-16/1961-01-22   7.417143   9.257143   7.875714   7.145714   8.124286   \n",
       "1961-01-23/1961-01-29  14.828571  15.528571  15.160000  14.480000  15.640000   \n",
       "1961-01-30/1961-02-05   9.107143  12.204286   8.548571   9.821429   9.460000   \n",
       "1961-02-06/1961-02-12  12.522857  14.934286  14.850000  14.064286  14.440000   \n",
       "1961-02-13/1961-02-19  11.868571   9.542857  12.128571  12.375714  13.542857   \n",
       "1961-02-20/1961-02-26  10.114286  11.150000  10.875714  10.392857  12.730000   \n",
       "1961-02-27/1961-03-05   9.238571  10.232857  11.130000  10.383333  12.370000   \n",
       "1961-03-06/1961-03-12   9.488571   6.881429   9.637143   9.885714  10.458571   \n",
       "1961-03-13/1961-03-19   8.652857  10.041429  10.220000  10.101429  11.627143   \n",
       "1961-03-20/1961-03-26   7.982857  10.774286   8.977143  10.904286  11.481429   \n",
       "1961-03-27/1961-04-02   9.165714  11.125714   9.061429  10.478333   9.631429   \n",
       "1961-04-03/1961-04-09   7.637143   7.107143   8.041429   8.161429   7.238571   \n",
       "1961-04-10/1961-04-16   4.947143   5.005714   4.994286   5.718571   6.178571   \n",
       "1961-04-17/1961-04-23   7.798571   9.000000   9.111429   8.767143   9.551429   \n",
       "1961-04-24/1961-04-30   5.197143   6.150000   6.377143   6.242857   6.124286   \n",
       "1961-05-01/1961-05-07  10.864286  11.435714  12.244286  11.677143  11.585714   \n",
       "1961-05-08/1961-05-14   6.391429   8.013333   7.052857   7.528571   7.822857   \n",
       "1961-05-15/1961-05-21   5.022857   5.695714   6.970000   6.847143   7.114286   \n",
       "1961-05-22/1961-05-28   4.112857   5.142857   6.272857   6.108571   7.535714   \n",
       "1961-05-29/1961-06-04   6.451429   8.344286   8.635714   8.714286   9.035714   \n",
       "1961-06-05/1961-06-11   5.460000   7.084286   6.884286   8.034286   8.397143   \n",
       "1961-06-12/1961-06-18   6.947143   9.278571   9.102857   8.992857   9.594286   \n",
       "1961-06-19/1961-06-25   7.492857  11.868571   9.447143  10.458571  11.257143   \n",
       "1961-06-26/1961-07-02   6.507143   7.642857   9.237143   7.904286  10.268571   \n",
       "1961-07-03/1961-07-09   7.982857  11.888333   9.308571  10.732857  10.547143   \n",
       "1961-07-10/1961-07-16   8.412857  10.171429  10.507143   9.530000  10.157143   \n",
       "1961-07-17/1961-07-23   2.715714   3.964286   5.642857   5.297143   6.041429   \n",
       "...                          ...        ...        ...        ...        ...   \n",
       "1978-06-05/1978-06-11   8.030000   8.678571   8.227143   9.172857   9.642857   \n",
       "1978-06-12/1978-06-18   6.898571   7.297143   7.464286   7.054286   6.225714   \n",
       "1978-06-19/1978-06-25   6.852857   7.648571   7.875714   7.865714   7.084286   \n",
       "1978-06-26/1978-07-02   9.005714  11.055714   8.917143   9.994286   7.498571   \n",
       "1978-07-03/1978-07-09  10.762857  11.368571  11.218571  11.272857  11.082857   \n",
       "1978-07-10/1978-07-16   2.631429   2.494286   3.540000   3.397143   3.214286   \n",
       "1978-07-17/1978-07-23   8.282857   8.147143   9.301429   8.952857   8.402857   \n",
       "1978-07-24/1978-07-30   8.707143   7.458571   9.117143   9.304286   8.148571   \n",
       "1978-07-31/1978-08-06   5.855714   7.065714   5.410000   6.631429   4.962857   \n",
       "1978-08-07/1978-08-13   6.702857   5.452857   5.964286   7.518571   5.661429   \n",
       "1978-08-14/1978-08-20   8.034286   7.267143   8.517143   9.815714   7.941429   \n",
       "1978-08-21/1978-08-27   4.077143   3.291429   3.500000   5.877143   4.447143   \n",
       "1978-08-28/1978-09-03   5.090000   6.184286   3.000000   6.202857   4.745714   \n",
       "1978-09-04/1978-09-10  10.927143   9.157143   9.458571  10.588571   8.274286   \n",
       "1978-09-11/1978-09-17  11.868571  13.017143  12.447143  11.908571  10.957143   \n",
       "1978-09-18/1978-09-24   5.171429   7.047143   6.750000   6.870000   6.291429   \n",
       "1978-09-25/1978-10-01  10.338571  15.124286  12.378571  12.275714  11.970000   \n",
       "1978-10-02/1978-10-08   8.881429   9.707143   9.708571  11.391429  10.161429   \n",
       "1978-10-09/1978-10-15   6.237143   5.577143   6.348571   7.232857   7.285714   \n",
       "1978-10-16/1978-10-22   6.862857   9.391429   7.428571   7.765714   8.048571   \n",
       "1978-10-23/1978-10-29   5.905714   8.727143   6.652857   7.605714   8.120000   \n",
       "1978-10-30/1978-11-05   8.314286   9.775714   9.638571  10.185714  10.422857   \n",
       "1978-11-06/1978-11-12   9.352857  10.224286  10.554286  11.168571  12.232857   \n",
       "1978-11-13/1978-11-19  11.208571  16.081429  12.915714  13.297143  13.242857   \n",
       "1978-11-20/1978-11-26   7.404286  12.797143   7.571429   9.998571   8.915714   \n",
       "1978-11-27/1978-12-03   8.618571   9.642857   7.685714   9.011429   9.547143   \n",
       "1978-12-04/1978-12-10  12.774286  14.437143  12.488571  13.870000  14.082857   \n",
       "1978-12-11/1978-12-17   7.272857  10.208571   7.967143   9.168571   8.565714   \n",
       "1978-12-18/1978-12-24   6.290000   7.798571   8.667143   7.151429   8.072857   \n",
       "1978-12-25/1978-12-31   8.620000  13.708571  10.477143  10.868571  11.471429   \n",
       "\n",
       "                             BEL        MAL  \n",
       "Yr_Mo_Dy                                     \n",
       "1960-12-26/1961-01-01  18.500000  15.040000  \n",
       "1961-01-02/1961-01-08  12.481429  13.238571  \n",
       "1961-01-09/1961-01-15  11.125714  11.024286  \n",
       "1961-01-16/1961-01-22   9.821429  11.434286  \n",
       "1961-01-23/1961-01-29  20.930000  22.530000  \n",
       "1961-01-30/1961-02-05  14.012857  11.935714  \n",
       "1961-02-06/1961-02-12  21.832857  19.155714  \n",
       "1961-02-13/1961-02-19  21.167143  16.584286  \n",
       "1961-02-20/1961-02-26  16.304286  14.322857  \n",
       "1961-02-27/1961-03-05  17.842857  13.951667  \n",
       "1961-03-06/1961-03-12  16.701429  14.420000  \n",
       "1961-03-13/1961-03-19  19.350000  16.227143  \n",
       "1961-03-20/1961-03-26  14.037143  18.134286  \n",
       "1961-03-27/1961-04-02  13.471429  13.900000  \n",
       "1961-04-03/1961-04-09  11.712857  11.371429  \n",
       "1961-04-10/1961-04-16   9.482857   8.690000  \n",
       "1961-04-17/1961-04-23  13.620000  12.470000  \n",
       "1961-04-24/1961-04-30   9.720000   8.637143  \n",
       "1961-05-01/1961-05-07  17.548571  14.571429  \n",
       "1961-05-08/1961-05-14  10.421429  10.382857  \n",
       "1961-05-15/1961-05-21   9.624286  10.612857  \n",
       "1961-05-22/1961-05-28  10.518571  11.697143  \n",
       "1961-05-29/1961-06-04  12.298571  13.597143  \n",
       "1961-06-05/1961-06-11  10.148571  12.250000  \n",
       "1961-06-12/1961-06-18  15.351429  15.025714  \n",
       "1961-06-19/1961-06-25  14.370000  17.410000  \n",
       "1961-06-26/1961-07-02  14.535714  12.133333  \n",
       "1961-07-03/1961-07-09  12.220000  15.987143  \n",
       "1961-07-10/1961-07-16  13.520000  12.524286  \n",
       "1961-07-17/1961-07-23   7.524286   8.415714  \n",
       "...                          ...        ...  \n",
       "1978-06-05/1978-06-11  11.632857  17.778571  \n",
       "1978-06-12/1978-06-18  11.398571  12.957143  \n",
       "1978-06-19/1978-06-25  13.030000  16.678571  \n",
       "1978-06-26/1978-07-02  12.268571  15.287143  \n",
       "1978-07-03/1978-07-09  14.754286  18.215714  \n",
       "1978-07-10/1978-07-16   7.198571   7.578571  \n",
       "1978-07-17/1978-07-23  13.847143  14.785714  \n",
       "1978-07-24/1978-07-30  15.192857  14.584286  \n",
       "1978-07-31/1978-08-06   9.084286  11.405714  \n",
       "1978-08-07/1978-08-13  10.691429  11.927143  \n",
       "1978-08-14/1978-08-20  15.000000  14.405714  \n",
       "1978-08-21/1978-08-27   8.131429  10.661429  \n",
       "1978-08-28/1978-09-03   8.105714  13.150000  \n",
       "1978-09-04/1978-09-10  14.560000  16.752857  \n",
       "1978-09-11/1978-09-17  18.422857  23.441429  \n",
       "1978-09-18/1978-09-24  13.447143  15.324286  \n",
       "1978-09-25/1978-10-01  19.160000  24.158571  \n",
       "1978-10-02/1978-10-08  16.498571  20.618571  \n",
       "1978-10-09/1978-10-15  12.197143  14.177143  \n",
       "1978-10-16/1978-10-22  12.708571  17.868571  \n",
       "1978-10-23/1978-10-29  14.487143  16.915714  \n",
       "1978-10-30/1978-11-05  18.451429  18.721429  \n",
       "1978-11-06/1978-11-12  19.307143  22.522857  \n",
       "1978-11-13/1978-11-19  20.357143  23.905714  \n",
       "1978-11-20/1978-11-26  15.207143  19.491429  \n",
       "1978-11-27/1978-12-03  11.835714  18.728571  \n",
       "1978-12-04/1978-12-10  18.517143  23.061429  \n",
       "1978-12-11/1978-12-17  11.102857  15.562857  \n",
       "1978-12-18/1978-12-24  11.845714  18.977143  \n",
       "1978-12-25/1978-12-31  12.947143  26.844286  \n",
       "\n",
       "[940 rows x 12 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(data.index.to_period('W')).mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 15. Calculate the min, max and mean windspeeds and standard deviations of the windspeeds across all locations for each week (assume that the first week starts on January 2 1961) for the first 52 weeks."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"4\" halign=\"left\">RPT</th>\n",
       "      <th colspan=\"4\" halign=\"left\">VAL</th>\n",
       "      <th colspan=\"2\" halign=\"left\">ROS</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">CLO</th>\n",
       "      <th colspan=\"4\" halign=\"left\">BEL</th>\n",
       "      <th colspan=\"4\" halign=\"left\">MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>...</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-08</th>\n",
       "      <td>10.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>13.541429</td>\n",
       "      <td>2.631321</td>\n",
       "      <td>6.63</td>\n",
       "      <td>16.88</td>\n",
       "      <td>11.486667</td>\n",
       "      <td>3.949525</td>\n",
       "      <td>7.62</td>\n",
       "      <td>12.33</td>\n",
       "      <td>...</td>\n",
       "      <td>8.497143</td>\n",
       "      <td>1.704941</td>\n",
       "      <td>5.46</td>\n",
       "      <td>17.54</td>\n",
       "      <td>12.481429</td>\n",
       "      <td>4.349139</td>\n",
       "      <td>10.88</td>\n",
       "      <td>16.46</td>\n",
       "      <td>13.238571</td>\n",
       "      <td>1.773062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-15</th>\n",
       "      <td>9.04</td>\n",
       "      <td>19.75</td>\n",
       "      <td>12.468571</td>\n",
       "      <td>3.555392</td>\n",
       "      <td>3.54</td>\n",
       "      <td>12.08</td>\n",
       "      <td>8.967143</td>\n",
       "      <td>3.148945</td>\n",
       "      <td>7.08</td>\n",
       "      <td>19.50</td>\n",
       "      <td>...</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>4.084293</td>\n",
       "      <td>5.25</td>\n",
       "      <td>20.71</td>\n",
       "      <td>11.125714</td>\n",
       "      <td>5.552215</td>\n",
       "      <td>5.17</td>\n",
       "      <td>16.92</td>\n",
       "      <td>11.024286</td>\n",
       "      <td>4.692355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-22</th>\n",
       "      <td>4.92</td>\n",
       "      <td>19.83</td>\n",
       "      <td>13.204286</td>\n",
       "      <td>5.337402</td>\n",
       "      <td>3.42</td>\n",
       "      <td>14.37</td>\n",
       "      <td>9.862857</td>\n",
       "      <td>3.837785</td>\n",
       "      <td>7.29</td>\n",
       "      <td>20.79</td>\n",
       "      <td>...</td>\n",
       "      <td>8.124286</td>\n",
       "      <td>4.783952</td>\n",
       "      <td>6.50</td>\n",
       "      <td>15.92</td>\n",
       "      <td>9.821429</td>\n",
       "      <td>3.626584</td>\n",
       "      <td>6.79</td>\n",
       "      <td>17.96</td>\n",
       "      <td>11.434286</td>\n",
       "      <td>4.237239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-29</th>\n",
       "      <td>13.62</td>\n",
       "      <td>25.04</td>\n",
       "      <td>19.880000</td>\n",
       "      <td>4.619061</td>\n",
       "      <td>9.96</td>\n",
       "      <td>23.91</td>\n",
       "      <td>16.141429</td>\n",
       "      <td>5.170224</td>\n",
       "      <td>12.67</td>\n",
       "      <td>25.84</td>\n",
       "      <td>...</td>\n",
       "      <td>15.640000</td>\n",
       "      <td>3.713368</td>\n",
       "      <td>14.04</td>\n",
       "      <td>27.71</td>\n",
       "      <td>20.930000</td>\n",
       "      <td>5.210726</td>\n",
       "      <td>17.50</td>\n",
       "      <td>27.63</td>\n",
       "      <td>22.530000</td>\n",
       "      <td>3.874721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-05</th>\n",
       "      <td>10.58</td>\n",
       "      <td>24.21</td>\n",
       "      <td>16.827143</td>\n",
       "      <td>5.251408</td>\n",
       "      <td>9.46</td>\n",
       "      <td>24.21</td>\n",
       "      <td>15.460000</td>\n",
       "      <td>5.187395</td>\n",
       "      <td>9.04</td>\n",
       "      <td>19.70</td>\n",
       "      <td>...</td>\n",
       "      <td>9.460000</td>\n",
       "      <td>2.839501</td>\n",
       "      <td>9.17</td>\n",
       "      <td>19.33</td>\n",
       "      <td>14.012857</td>\n",
       "      <td>4.210858</td>\n",
       "      <td>7.17</td>\n",
       "      <td>19.25</td>\n",
       "      <td>11.935714</td>\n",
       "      <td>4.336104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-12</th>\n",
       "      <td>16.00</td>\n",
       "      <td>24.54</td>\n",
       "      <td>19.684286</td>\n",
       "      <td>3.587677</td>\n",
       "      <td>11.54</td>\n",
       "      <td>21.42</td>\n",
       "      <td>16.417143</td>\n",
       "      <td>3.608373</td>\n",
       "      <td>13.67</td>\n",
       "      <td>21.34</td>\n",
       "      <td>...</td>\n",
       "      <td>14.440000</td>\n",
       "      <td>1.746749</td>\n",
       "      <td>15.21</td>\n",
       "      <td>26.38</td>\n",
       "      <td>21.832857</td>\n",
       "      <td>4.063753</td>\n",
       "      <td>17.04</td>\n",
       "      <td>21.84</td>\n",
       "      <td>19.155714</td>\n",
       "      <td>1.828705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-19</th>\n",
       "      <td>6.04</td>\n",
       "      <td>22.50</td>\n",
       "      <td>15.130000</td>\n",
       "      <td>5.064609</td>\n",
       "      <td>11.63</td>\n",
       "      <td>20.17</td>\n",
       "      <td>15.091429</td>\n",
       "      <td>3.575012</td>\n",
       "      <td>6.13</td>\n",
       "      <td>19.41</td>\n",
       "      <td>...</td>\n",
       "      <td>13.542857</td>\n",
       "      <td>2.531361</td>\n",
       "      <td>14.09</td>\n",
       "      <td>29.63</td>\n",
       "      <td>21.167143</td>\n",
       "      <td>5.910938</td>\n",
       "      <td>10.96</td>\n",
       "      <td>22.58</td>\n",
       "      <td>16.584286</td>\n",
       "      <td>4.685377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-26</th>\n",
       "      <td>7.79</td>\n",
       "      <td>25.80</td>\n",
       "      <td>15.221429</td>\n",
       "      <td>7.020716</td>\n",
       "      <td>7.08</td>\n",
       "      <td>21.50</td>\n",
       "      <td>13.625714</td>\n",
       "      <td>5.147348</td>\n",
       "      <td>6.08</td>\n",
       "      <td>22.42</td>\n",
       "      <td>...</td>\n",
       "      <td>12.730000</td>\n",
       "      <td>4.920064</td>\n",
       "      <td>9.59</td>\n",
       "      <td>23.21</td>\n",
       "      <td>16.304286</td>\n",
       "      <td>5.091162</td>\n",
       "      <td>6.67</td>\n",
       "      <td>23.87</td>\n",
       "      <td>14.322857</td>\n",
       "      <td>6.182283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-05</th>\n",
       "      <td>10.96</td>\n",
       "      <td>13.33</td>\n",
       "      <td>12.101429</td>\n",
       "      <td>0.997721</td>\n",
       "      <td>8.83</td>\n",
       "      <td>17.00</td>\n",
       "      <td>12.951429</td>\n",
       "      <td>2.851955</td>\n",
       "      <td>8.17</td>\n",
       "      <td>13.67</td>\n",
       "      <td>...</td>\n",
       "      <td>12.370000</td>\n",
       "      <td>1.593685</td>\n",
       "      <td>11.58</td>\n",
       "      <td>23.45</td>\n",
       "      <td>17.842857</td>\n",
       "      <td>4.332331</td>\n",
       "      <td>8.83</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.951667</td>\n",
       "      <td>3.021387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-12</th>\n",
       "      <td>4.88</td>\n",
       "      <td>14.79</td>\n",
       "      <td>9.376667</td>\n",
       "      <td>3.732263</td>\n",
       "      <td>8.08</td>\n",
       "      <td>16.96</td>\n",
       "      <td>11.578571</td>\n",
       "      <td>3.230167</td>\n",
       "      <td>7.54</td>\n",
       "      <td>16.38</td>\n",
       "      <td>...</td>\n",
       "      <td>10.458571</td>\n",
       "      <td>3.655113</td>\n",
       "      <td>10.21</td>\n",
       "      <td>22.71</td>\n",
       "      <td>16.701429</td>\n",
       "      <td>4.358759</td>\n",
       "      <td>5.54</td>\n",
       "      <td>22.54</td>\n",
       "      <td>14.420000</td>\n",
       "      <td>5.769890</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT                                VAL                    \\\n",
       "              min    max       mean       std    min    max       mean   \n",
       "Yr_Mo_Dy                                                                 \n",
       "1961-01-08  10.58  18.50  13.541429  2.631321   6.63  16.88  11.486667   \n",
       "1961-01-15   9.04  19.75  12.468571  3.555392   3.54  12.08   8.967143   \n",
       "1961-01-22   4.92  19.83  13.204286  5.337402   3.42  14.37   9.862857   \n",
       "1961-01-29  13.62  25.04  19.880000  4.619061   9.96  23.91  16.141429   \n",
       "1961-02-05  10.58  24.21  16.827143  5.251408   9.46  24.21  15.460000   \n",
       "1961-02-12  16.00  24.54  19.684286  3.587677  11.54  21.42  16.417143   \n",
       "1961-02-19   6.04  22.50  15.130000  5.064609  11.63  20.17  15.091429   \n",
       "1961-02-26   7.79  25.80  15.221429  7.020716   7.08  21.50  13.625714   \n",
       "1961-03-05  10.96  13.33  12.101429  0.997721   8.83  17.00  12.951429   \n",
       "1961-03-12   4.88  14.79   9.376667  3.732263   8.08  16.96  11.578571   \n",
       "\n",
       "                        ROS         ...        CLO              BEL         \\\n",
       "                 std    min    max  ...       mean       std    min    max   \n",
       "Yr_Mo_Dy                            ...                                      \n",
       "1961-01-08  3.949525   7.62  12.33  ...   8.497143  1.704941   5.46  17.54   \n",
       "1961-01-15  3.148945   7.08  19.50  ...   7.571429  4.084293   5.25  20.71   \n",
       "1961-01-22  3.837785   7.29  20.79  ...   8.124286  4.783952   6.50  15.92   \n",
       "1961-01-29  5.170224  12.67  25.84  ...  15.640000  3.713368  14.04  27.71   \n",
       "1961-02-05  5.187395   9.04  19.70  ...   9.460000  2.839501   9.17  19.33   \n",
       "1961-02-12  3.608373  13.67  21.34  ...  14.440000  1.746749  15.21  26.38   \n",
       "1961-02-19  3.575012   6.13  19.41  ...  13.542857  2.531361  14.09  29.63   \n",
       "1961-02-26  5.147348   6.08  22.42  ...  12.730000  4.920064   9.59  23.21   \n",
       "1961-03-05  2.851955   8.17  13.67  ...  12.370000  1.593685  11.58  23.45   \n",
       "1961-03-12  3.230167   7.54  16.38  ...  10.458571  3.655113  10.21  22.71   \n",
       "\n",
       "                                   MAL                              \n",
       "                 mean       std    min    max       mean       std  \n",
       "Yr_Mo_Dy                                                            \n",
       "1961-01-08  12.481429  4.349139  10.88  16.46  13.238571  1.773062  \n",
       "1961-01-15  11.125714  5.552215   5.17  16.92  11.024286  4.692355  \n",
       "1961-01-22   9.821429  3.626584   6.79  17.96  11.434286  4.237239  \n",
       "1961-01-29  20.930000  5.210726  17.50  27.63  22.530000  3.874721  \n",
       "1961-02-05  14.012857  4.210858   7.17  19.25  11.935714  4.336104  \n",
       "1961-02-12  21.832857  4.063753  17.04  21.84  19.155714  1.828705  \n",
       "1961-02-19  21.167143  5.910938  10.96  22.58  16.584286  4.685377  \n",
       "1961-02-26  16.304286  5.091162   6.67  23.87  14.322857  6.182283  \n",
       "1961-03-05  17.842857  4.332331   8.83  17.54  13.951667  3.021387  \n",
       "1961-03-12  16.701429  4.358759   5.54  22.54  14.420000  5.769890  \n",
       "\n",
       "[10 rows x 48 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# resample data to 'W' week and use the functions\n",
    "weekly = data.resample('W').agg(['min','max','mean','std'])\n",
    "\n",
    "# slice it for the first 52 weeks and locations\n",
    "weekly.loc[weekly.index[1:53], \"RPT\":\"MAL\"] .head(10)"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
